Expanding Selection Range

[Jim May]

In my code the current range that is selection via
Selection. is A5:C3000; what next line of code
would change the Selection to A53000? (one additional
column to be included)
TIA,
Jim May

 

[Tom Ogilvy]

selection.Resize(,selection.columns.count+1).Select

 

[Frank Kabel]

Hi
selection.resize(0,1)

 

[Tom Ogilvy]

Frank,
You can't resize the selection to zero rows. Not sure where you were going
with this, but it was/is the wrong direction.

Selection.Resize(,4) perhaps.

 

[Frank Kabel]

Hi Tom
correct, thanks for the correction (forgot to remove the zero)

 

[Jim May]

Perfect Tom!
Tks again and agian...
Jim May

-----Original Message-----
selection.Resize(,selection.columns.count+1).Select

--
Regards,
Tom Ogilvy




.