will this work?

activesheet.usedrange.range("a1").Address

--


Gary


"Bob Phillips" wrote in message
...
cells(activesheet.usedrange.row,activesheet.usedra nge.column)

will give you the first used cell

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"DFDY" wrote in message
...
I use the (Sheet).UsedRange.Columns.Count in my code, so I need a first used
cell position to copy all the cells to the array.

Excel 2003

Can you leave the hyperlink for the object library here? I can't find it on
MSDN. Thank you in advance!