Posted to microsoft.public.excel.programming

Katie[_2_] Katie[_2_] is offline

external usenet poster

Posts: 4

Error Message in VB

I set up a macro to do the following:

If Not rng Is Nothing Then sh.Range("A1").Copy
Destination:=rng
Selection.PasteSpecial Paste:=xlValues,
Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False

....and it gives me error message 1004. Could you please
tell me what's wrong with the above script? Thank you.

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
Getting Rid of Error Message	rvExcelNewTip	Charts and Charting in Excel	7	January 14th 06 02:10 PM
VBA Error Message "Compile Error...."	Steve	Excel Discussion (Misc queries)	3	July 15th 05 09:20 AM
changing the message in an error message	The Villages DA	Excel Worksheet Functions	2	February 18th 05 05:30 PM
How do I get rid of "Compile error in hidden module" error message	David	Excel Discussion (Misc queries)	4	January 21st 05 11:39 PM
Error message	Rob Bovey	Excel Programming	0	September 17th 03 10:42 PM

All times are GMT +1. The time now is 03:40 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us