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.