You might be interested in my recent universal last row function.
It gets the last row from a worksheet, a range or a column and accommodates for Lists or Tables.
free... http://blog.contextures.com/archives...ith-excel-vba/
--
Jim Cone
Portland, Oregon USA .
http://www.mediafire.com/PrimitiveSoftware .
(Data Rows add-in: Custom Shading, Deleting, Inserting)




"kittronald"
wrote in message
...
Jim,

Thanks, that works !

Using that code, I'm trying to fill down to the last used row.

For example:

A B C D
1 ABC 1 2 3
2 BCD
3 CDE
4 DEF
5 EFG


In this case, B1:D1 would be filled down to row 5.

However, the rows used in column A varies and I'm trying to fill down to the last used row with
code similar to:

Range(Selection, Selection.SpecialCells(xlCellTypeLastCell)).Select

Selection.FillDown

Is there a way to specify the last used row ?



- Ronald K.