selecting a variable range
Posted by Krista on June 18, 2001 1:46 PM
I am trying to use a macro to select an unknown range of cells. The macro searches for the last line in a column and identifies the number of the last row, defined as variable "L".
How can I use this variable in the range command, along with my column variable, col?
I have gotten the command Cells to work with these variables for single cells, but not a range of them. I have tried: Range(col & 1: col & L) etc with no luck.
What can I do to correct this or what am I doing wrong?