Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Contiguous Column Selection using variables
Hello,
I am looking for a way to select 28 contiguous columns using variables. x = Activecell.Column I would like to select the column after x (say 22, through 40) I know the following works: Columns(x+1).select would only select the first column but how do I select the remaining 28 columns? Thank you Leslie |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Contiguous Column Selection using variables
Columns(x+1).Resize(,28).select
-- Regards, Tom Ogilvy "Leslie Payne" wrote in message om... Hello, I am looking for a way to select 28 contiguous columns using variables. x = Activecell.Column I would like to select the column after x (say 22, through 40) I know the following works: Columns(x+1).select would only select the first column but how do I select the remaining 28 columns? Thank you Leslie |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Contiguous Column Selection using variables
Hi Leslie,
Try this ActiveCell.Resize(1, x).EntireColumn.Select -- HTH RP "Leslie Payne" wrote in message om... Hello, I am looking for a way to select 28 contiguous columns using variables. x = Activecell.Column I would like to select the column after x (say 22, through 40) I know the following works: Columns(x+1).select would only select the first column but how do I select the remaining 28 columns? Thank you Leslie |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Contiguous Column Selection using variables
Leslie Payne wrote:
Hello, I am looking for a way to select 28 contiguous columns using variables. x = Activecell.Column I would like to select the column after x (say 22, through 40) I know the following works: Columns(x+1).select would only select the first column but how do I select the remaining 28 columns? Thank you Leslie 23 through is only 18 columns. Alan Beban |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Non-contiguous selection | Excel Discussion (Misc queries) | |||
Finding last column in non-contiguous range | Excel Worksheet Functions | |||
add all contiguous numbers-column-row | New Users to Excel | |||
Non-contiguous selection | Excel Programming | |||
Help : Code for selection non-contiguous cells | Excel Programming |