Range Address Variables

[em07189]

Hello everyone,

instead of write A, which is the column in a excel sheet in the

 Range("A" & i)

expression ,is it possible to put a variable in the place of the "A" letter that identifies the column?

Thanks.

[rollis13]

Use instead:

Cells(i, x)

where x is the variable for the column (in numbers).

[Aflatoon]

Or letters. Either work with Cells().