View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Opa Horst Opa Horst is offline
external usenet poster
 
Posts: 9
Default VB Script XL - Range Selection

Close :) Split the command in two, first get the last row:
Lastrow = Range(Cells(13,ColNbr),Cells(13,ColNbr)).End(xlDow n).Row
Then go right:
Cells(Lastrow,ColNbr+23).Activate


"Servant63" wrote:

I'm new to Scripting in Excel and trying to select a Range of cells beginning
at B13... want to End-down and then go right 23 cells and have that range
active to print... Closest I've come is
Range ("B13".End(xlDown)).Right 23.Activate {I've thrown in Right 23 as I
don't know how to include that part}... thanx in advance...