Hi:
Hopefully this is a simple process. I am using the following code in a Macro to paste some data.
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
Hopefully this is a simple process. I am using the following code in a Macro to paste some data.
Code:
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