Tweek Paste Code (VBA)?

[Mister H]

Hi:

Hopefully this is a simple process. I am using the following code in a Macro to paste some data.

Selection.PasteSpecial Paste:=xlFormats, Operation:=xlNone, SkipBlanks:= _
        False, Transpose:=False

When I originally requested this code I only needed to copy the formatting however I have since added in formulas that are alos required. Can you PasteSpecial more then one option? Does this make sense? I need to paste the formatting but also some formulas? I assume if I Paste Special the formulas the formatting will not be pasted?

THANKS to any that can guide me,
Mark

 

[jss1234]

Selection.PasteSpecial Paste:=xlFormulas
Selection.PasteSpecial Paste:=xlFormats

This will first paste formats, then paste formulas - 2 lines of code, but you already copied the data and set the past range

 

[Mister H]

THANKS... Excuse my VBA ignorance but do I just paste the

Selection.PasteSpecial Paste:=xlFormulas after the xlFormats?

eg.

Selection.PasteSpecial Paste:=xlFormats, Selection.PasteSpecial Paste:=xlFormulas, Operation:=xlNone, SkipBlanks:= _ 
        False, Transpose:=False

The above is just part of the code I am using but it is the part that Pastes the selection.

THANKS Again,
Mark

 

[jss1234]

I re-ordered the code above - just replace the original code you had with the code I provided, and it should work