Macto to copy data untill last used column

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

Please Login or Register  to view this content.

, but it copy formula untill last last column, which I don't need.

Thank you,
Andy :-)

super, that works for me :-)
Could you please help me, how to modify this macro a bit and write there: to copy this formula as well to each row based on column "A" ?

I just wanted to ask if there is possibility to update your code, that my formula will be copy pasted untill last column based on column "C" ( what you did already) and untill last rows based on column "A", starting with cell "A3" ?

Originally Posted by dobracik

super, that works for me :-)
Could you please help me, how to modify this macro a bit and write there: to copy this formula as well to each row based on column "A" ?

If you are asking how to insert a comment in the macro itself to describe what is happening then type it like this wherever you see fitting:

'to copy this formula as well to each row based on column "A"

No, I was just asking for help to modify macro which AlphaFrog gave it to me.
It should be like this : that my formula will be copy pasted untill last column based on column "C" ( what you did already) and untill last rows based on column "A", starting with cell "A3" ?

So sorry for confusion

Is thete anybody who could help me with that?

Thanks,
Andy

Thanks works perfect.