Problem copying with macro

[bryan444]

Hello

I would like to select a zone of a range that only has something in the rows

here is my code

Please Login or Register  to view this content.

And please find attached the file i would like to select the range "heud"

Best regards

R

[bryan444]

I modified the title to be more precise

[AB33]

R,
You have already created "Named Range" in sheet 1. All you need to do is change the range- CTR+F3

[Norie]

What exactly do you want to copy?

Your named range is from C:XFD and your data is in C5:K114 with some sort of headers in C4, E4, G4, I4 and K4.

[bryan444]

Actually the data is dynamic
more I have completed rows under the "Stocks" (column A)
More I will have data to copy starting C4 till ...

Thanks a lot for your help guys
R