copy sheet while keeping column widths and row heights the same as the master sheet.

Good Day All

I am using

Please Login or Register  to view this content.

To copy my master sheet over to multiple sheets, however the copied sheets column width and row height differs from that of my master sheet.

Please can anyone help to rectify that within the code i am using.

Thanks in advance for any help offered. Really, Really appreciate you guys and gals

Try
Ws.Range("A1").PasteSpecial xlPasteColumnWidths
Ws.Range("A1").PasteSpecial xlPasteRowHeights
Ws.Range("A1").PasteSpecial xlPasteFormats

(Formats does colours etc.)

Mind you, I'm not that crash hot at this. but I've had a similar problem and use this to get around it!!

Frankie

lol, turns out you are that crack at it. Thank you Frankie...works a charm....