copy and paste all but formulas

[stevenfarrar]

i have a large spread sheet that I use to gather and process many
customer's information.

I need a way to copy and paste items from that spreadsheet and not
copy the formulas.

I could copy just the values but then I lose all the wonderful
formatting.

For information security reasons I need to be able to copy all values
formatting, borders, etc... and leave out the formulas.


Can this be done?

Thanks,
Steven Farrar
Farrar digital Solutions

 

[Roger Govier]

Hi

Copy the Data>Paste Special>Values followed immediately by Paste
Special>Formats.

 

[stevenfarrar]

Hi

Copy the Data>Paste Special>Values followed immediately by Paste
Special>Formats.

I was really searching for something in one step. Some of my users
are not the sharpest knife in the drawer

 

[Roger Govier]

Hi Steven

Maybe you could just give them a simple macro like the following and
give it an action of Ctrl+Q or put it on a button for them.
Then they could make their copy, move to destination and do Ctrl+q or
press the button.

Sub PasteValueandFormat()

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
End Sub