A couple of possible problems but it is hard to fix without seeing the
rest
of the code. Post the entire macro and we can take a look.

"RobinTaylor" wrote:


Thanks for you quick response, Jim. My showcase menu is there, so
that's all
good. But even if I remove that line and run the macro, the other
recorded
line crashes. This one:

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

I get runtime error 1004:
Pastespecial method of range Class failed.


"Jim Thomlinson" wrote:


It has to do with Showcase Query and it is really not necessary for
whatever
you are doing. Just confirm that you have your Showcase query menu and
you
are good to go. If you do not have the menu then you can just re-boot
your
Excel and it will come back...

"RobinTaylor" wrote:


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!