VBA compile error on simple copy-paste special

**DJDRU** · 02-10-2017, 11:19 AM

Hello,

I am not understanding why this error is occurring or how to correct it. The macro was recorded and when run through VBA it returns an error. I have attached a screenshot below. Any help is greatly appreciated.

**xlnitwit** · 02-10-2017, 11:28 AM

Hi,

Don't select, it merely slows the code down. Use

Range().Copy
Range().Pastespecial ...

If you'd pasted the code instead of a picture I would have edited it for you.

**DJDRU** · 02-10-2017, 11:56 AM

Thank you very much. This fixed it, but I'm still stuck on why this would happen.

**xlnitwit** · 02-10-2017, 12:42 PM

It would seem that the Selection was not a range for some reason.

VBA compile error on simple copy-paste special

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

VBA compile error on simple copy-paste special

Re: VBA compile error on simple copy-paste special

Re: VBA compile error on simple copy-paste special

Re: VBA compile error on simple copy-paste special

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] [Simple] Paste special macro (I already have most of the code)?

[SOLVED] Compile Error: Invalid Use of Property on stupidly simple code

[SOLVED] Runtime Error 13 for simple copy/paste loop

[SOLVED] Simple copy and paste macro- Paste special help needed.

compile error on simple End.xldown code

Compile error in copy/paste code

error using copy and paste special macro in France and Germany

Bookmarks

Bookmarks

Posting Permissions