Hi all :-)

Hope, that anybody could help me with that.

I have a dynamic name list in first row, starting from cell C1 and continuing to the right. What I want is just to copy formula which I have in cell A1 and copy it to third row starting from the Cell "C3" until last used column, based on first row?

What I used now is 
 Range(Selection, Selection.End(xlToRight)).Select
, but it copy formula untill last last column, which I don't need.

Thank you,
Andy :-)