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