VB Script XL - Range Selection

  • Thread starter Thread starter Servant63
  • Start date Start date
S

Servant63

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...
 
Try

Range("B13").End(xlDown)(1, 24).Activate

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]
 
Close :) Split the command in two, first get the last row:
Lastrow = Range(Cells(13,ColNbr),Cells(13,ColNbr)).End(xlDown).Row
Then go right:
Cells(Lastrow,ColNbr+23).Activate
 
Back
Top