copy and paste all but formulas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

stevenfarrar@gmail.com - 02 Feb 2007 22:44 GMT

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

Reply to this Message

Roger Govier - 02 Feb 2007 22:58 GMT

Hi

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

Signature

Regards

Roger Govier

>i have a large spread sheet that I use to gather and process many
> customer's information.
[quoted text clipped - 13 lines]
> Steven Farrar
> Farrar digital Solutions

Reply to this Message

stevenfarrar@gmail.com - 02 Feb 2007 23:13 GMT

On Feb 2, 4:58 pm, "Roger Govier" <r...@technologyNOSPAM4u.co.uk>
wrote:

> Hi
>
[quoted text clipped - 27 lines]
> > Steven Farrar
> > Farrar digital Solutions

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

Reply to this Message

Roger Govier - 03 Feb 2007 11:36 GMT

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

Signature

Regards

Roger Govier

> On Feb 2, 4:58 pm, "Roger Govier" <r...@technologyNOSPAM4u.co.uk>
> wrote:
[quoted text clipped - 33 lines]
> I was really searching for something in one step. Some of my users
> are not the sharpest knife in the drawer

Reply to this Message