Resolved >>> Copying formatting for 40K+ rows

[brandon]

I have to copy the formatting from "rows G&H" for 40,000+ lines. Is there an easier way than doing the formatting then highlighting the first two cells (G4 and H4) then dragging the bottom right hand corner down 40,000 lines?

Any help would be appreciated!

[VBA Noob]

See if this helps. Select G4 and H4 > press paint brush > Ctrl + Shift down arrow.

This assumes no gaps in data

VBA Noob

[brandon]

Well, that highlighted the cells BUT it didn't copy the formatting. The cells were just highlighted but left blank. I don't think I am using the paint brush (format painter) correctly. It does not copy the formatting all the way down.

The Ctrl+Shft+down arrow did highlight all the cells. Darn formatting didn't copy over though. Any ideas?

[VBA Noob]

Maybe take a look at how paint brush works again just in case it's that

http://www.bettersolutions.com/excel...T321112321.htm

http://office.microsoft.com/en-us/ex...116591033.aspx

VBA Noob

[brandon]

Thank you! I did the format cop but not paste...duh!

That saves a lot of time!!! It worked.

[VBA Noob]

Good to hear

VBA Noob