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

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

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