Thanks for your help. I am just learning to use visual basic. So, the obvious
answers are sometimes hidden in my lack of knowledge.
--
dr chuck


"R..VENKATARAMAN" wrote:

probably I have not understood;l
activecell.End(xlDown).offset(1,0).Select
will take to the first empty cell (it should be really empty) in the column

if your want to select the range from the activecell upto the first empty
cell then use

range(activecell,activecell.End(xlDown).Offset(1,0 )).Select

This will select from activecell to the first empty cell.


"dr chuck" wrote in message
...
i am using a loop and active cell offset to get to the first empty cell in
a
specified column.

Do
ActiveCell.offset(1, 0).Select
Loop Until ActiveCell.Value = ""

after arriving at the active cell that the loop selects, i want to use
the
active cell in a range command.

Range("A10:Ai2000").Select

i want to use whatever the active cell is in place of the "A10" above.

any ideas?




--
dr chuck