| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Expanding Range in Formula? | Excel Discussion (Misc queries) | |||
| Expanding a named range | Excel Worksheet Functions | |||
| Expanding a Range Automatically | Excel Discussion (Misc queries) | |||
| Expanding Selection | Excel Discussion (Misc queries) | |||
| sorting data and expanding the selection | Excel Discussion (Misc queries) | |||
![Jim May[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
