Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select column in VB based on variable
Hi all,
I would like my code to select a column (or range of columns) based on a variable passed from another subroutine, but I'm not sure how to do it. Example 1: I would like to select the columns starting at column 2 (B) up to column ColCount (my variable). So if ColCount=6, the macro would select columns B through F Example 2: I would like the macro to select column ColCount+1 (So if ColCount = 6, column G should be selected) Example 3: I would like the macro to select columns ColCount+3 and ColCount+4 (So if ColCount = 6, columns I and J should be selected). Many thanks, James |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select column in VB based on variable
For your first example:
Sub dural() colcnt = 6 Range(Cells(1, 2), Cells(1, colcnt)).EntireColumn.Select End Sub -- Gary''s Student - gsnu200806 "James" wrote: Hi all, I would like my code to select a column (or range of columns) based on a variable passed from another subroutine, but I'm not sure how to do it. Example 1: I would like to select the columns starting at column 2 (B) up to column ColCount (my variable). So if ColCount=6, the macro would select columns B through F Example 2: I would like the macro to select column ColCount+1 (So if ColCount = 6, column G should be selected) Example 3: I would like the macro to select columns ColCount+3 and ColCount+4 (So if ColCount = 6, columns I and J should be selected). Many thanks, James |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select column in VB based on variable
Thanks Gary :)
This, combined with selection.offset has given me what I need. James. "Gary''s Student" wrote: For your first example: Sub dural() colcnt = 6 Range(Cells(1, 2), Cells(1, colcnt)).EntireColumn.Select End Sub -- Gary''s Student - gsnu200806 "James" wrote: Hi all, I would like my code to select a column (or range of columns) based on a variable passed from another subroutine, but I'm not sure how to do it. Example 1: I would like to select the columns starting at column 2 (B) up to column ColCount (my variable). So if ColCount=6, the macro would select columns B through F Example 2: I would like the macro to select column ColCount+1 (So if ColCount = 6, column G should be selected) Example 3: I would like the macro to select columns ColCount+3 and ColCount+4 (So if ColCount = 6, columns I and J should be selected). Many thanks, James |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I am trying to select a new cell whose row address is based on a variable | Excel Programming | |||
How do I select a cell based on the Column name | Excel Programming | |||
Select a column based on a index | Excel Programming | |||
Sum cells based on a row variable and seperate column variable | Excel Worksheet Functions | |||
Select Cell based on Variable address | Excel Programming |