Paste formats from row1 to all rows with data

Hi guys,

I´m trying to select row1 and paste its formats only to all rows containing data in the worksheet.

I´ve been using the code bellow to copy row1 and paste it to the last row of the sheet and it works fine, but need another macro for another sheet that does the above.

Please Login or Register  to view this content.

Thanks

Originally Posted by VBA Noob

Please remember to wrap code next time as per forum rules below

Maybe the below will help

Please Login or Register  to view this content.

VBA Noob

Hi,

Thanks for the quick reply. I get an error message 1004 when I try this code.
"couldnt find cells"

I see the error message is based on this line:

Please Login or Register  to view this content.

If I use this instead

Please Login or Register  to view this content.

I get the code to work but it only pasted the format from row 1 to last row. I want it to paste the format to all rows lets say from row 3 till last row containing data +1

any idea why i´m getting this?

Originally Posted by VBA Noob

Maybe

Please Login or Register  to view this content.

VBA Noob

Hi VBA,

Apologies for the late reply. I try to get as far away from a computer on the weekends as I can

The code works as a charm! thanks for everything.

I´m trying to understand the code though. Imagine I want the code to apply the format from row 3 onwards, instead of row 2, row would I do that?