Paste Formats, number formats and formulas

[ThreeBlindMice]

Have seen posts on how to paste "Values and Formats" or "Number formats and formulas". I am looking to find a way for VBA to paste both formats and formulas all at once if possible. Currently I am copy and pasting the format and then going back and pasting the formulas in a second step.

 

[Jonmo1]

Welcome to the board.

How bout xlPasteAll

Range(...).Copy
Range(...).PasteSpecial xlPasteAll


or just a regular copy/paste without the pastespecial
Range(...).Copy Destination:=Range(...)

 

[ThreeBlindMice]

Well that was easy. Thanks a lot.

 

[Jonmo1]

Glad to help, thanks for the feedback.