Posted to microsoft.public.excel.programming

external usenet poster

Posts: 334

PasteSpecial Constant

When using this function : Selection.PasteSpecial
Paste:=xlValues,Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False

How do I change it to past a Public Constant?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
vba constant value for "Unicode Text" in PasteSpecial function	Bourgui	Excel Worksheet Functions	0	September 5th 08 08:32 PM
Why need to use Selection.PasteSpecial vs myRange.PasteSpecial	[email protected]	Excel Programming	4	June 25th 07 05:34 PM
Constant loan payments vs. constant payments of principal	lalli945	Excel Worksheet Functions	3	December 20th 06 10:33 PM
PasteSpecial	Kevin	Excel Programming	3	October 7th 04 01:07 PM
vba pastespecial	joao	Excel Programming	2	November 14th 03 03:31 PM

All times are GMT +1. The time now is 10:36 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us