Mega Code Archive

 
Categories / VisualBasic Script / Excel
 

Select a range and activate another

Public Sub SelectAndActivate()   Range("B3:E10").Select   Range("C5").Activate End Sub