Recorded macro won't run

R

rjamison

I recorded a simple macro to copy data from a worksheet and paste it into
a
new blank worksheet. In the recorded code was the line:

Application.Run Range("ScOnWindow")

When I ran the code, I got an error on this line. Normally I remove these
"sconwindow" lines from the code anyway, but it concerns me that something
I
just recorded will not run. Am I missing a reference library or
something?
It will also crash on the following recorded line:

Selection.PasteSpecial Paste:=xlColumnWidths, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False

Any help would be appreciated! Thanks!
 
J

Jim Thomlinson

SCon Window has to do with showcase query. Just delete the line. You don't
need it... The crash ahs to do with a Glitch in Excel. Replace
Paste:=xlColumnWidths with Paste:=8
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Recorded macro won't run 8
telling a macro to go back to where it came from 2
Having difficulty copying and pasting on VBA 3
Help merging two VBA codes 2
Data Validation won't copy 9
Macro Related to Paste Values 2
Ignoring a blank cell while running a macro. 1
Streamlining macro created by macro recorder 3

Top