Variable for column selection

[Mats W.]

Hi,

I use the script;
Range("D" & Rows.Count).End(xlUp).Offset(1).Select
...to check for the last row in a given column.

but I need to change the column D to a variable. I tried different ways to
write that without success. Appreciate if someone can give a hint!

Thanks!
--
Mats W.

[Toppers]

One way:

Dim colvar As String
colvar = "D"
Range(colvar & Rows.Count).End(xlUp).Offset(1).Select

"Mats W." wrote:

> Hi,
>
> I use the script;
> Range("D" & Rows.Count).End(xlUp).Offset(1).Select
> ..to check for the last row in a given column.
>
> but I need to change the column D to a variable. I tried different ways to
> write that without success. Appreciate if someone can give a hint!
>
> Thanks!
> --
> Mats W.

[Bob Phillips]

Dim iCol As Long


Cells(Rows.Count, iCol).End(xlUp).Offset(1).Select

--
HTH

Bob Phillips

"Mats W." <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I use the script;
> Range("D" & Rows.Count).End(xlUp).Offset(1).Select
> ..to check for the last row in a given column.
>
> but I need to change the column D to a variable. I tried different ways to
> write that without success. Appreciate if someone can give a hint!
>
> Thanks!
> --
> Mats W.