Expanding Selection Range
 

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

Expanding Selection Range
 

selection.Resize(,selection.columns.count+1).Selec t

--
Regards,
Tom Ogilvy

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

Expanding Selection Range
 

Hi
selection.resize(0,1)

--
Regards
Frank Kabel
Frankfurt, Germany


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

Expanding Selection Range
 

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.

--
Regards,
Tom Ogilvy


"Frank Kabel" wrote in message
...
Hi
selection.resize(0,1)

--
Regards
Frank Kabel
Frankfurt, Germany


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

Expanding Selection Range
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


Tom Ogilvy wrote:
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" wrote in message
...
Hi
selection.resize(0,1)

--
Regards
Frank Kabel
Frankfurt, Germany


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

Expanding Selection Range
 

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


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

--
Regards,
Tom Ogilvy

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


.