Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recorded macro won't run
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 -- HTH... Jim Thomlinson "rjamison" 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
How to FIX Recorded Macro | Excel Discussion (Misc queries) | |||
Recorded Macro | New Users to Excel | |||
Recorded macro won't run | Excel Programming | |||
Recorded macro won't run | Excel Programming |