Paste Special - All but formulas

[Guest]

I would like to have the ability to do a paste special that includes values,
formats, and comments but excludes formulas. Either the option to do that or
the ability to select mutli paste specials at once would be a great time
saver versus having to do it three times. Thanks.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions

 

[Guest]

you could put a macro like this in your personal macro workbook and assign it
to a hotkey or to a button on your toolbar. Then copy whatever cell(s) you
need, select the destination, and run this macro (using hotkey or button on
toolbar).

Sub PasteSP()
With Selection
.PasteSpecial xlPasteValues
.PasteSpecial xlPasteComments
.PasteSpecial xlPasteFormats
End With
Application.CutCopyMode = False
End Sub

 

[Guest]

I just set the macro up and it makes a huge difference. Thanks!

 

[Guest]

Glad to help. I use a similar macro for PasteSpecial operations. I seem to
do it quite a bit and it gets tiresome going through the menu.

 

[ramana]

Hi Everbody,

The qustion raised is very useful, I wnted to vote for this
question when visted the microsoft web site they are asking to sign in
with thier .net passport where many of the people will not have .net
passport or the hotmail ID.

Regards

Ramana

 

[Guest]

It thoroughly impressed everyone in my accounting department and they all
wanted it set up on their computers. Big time saver.