Macro failed in transfer to VB code

I created a macro to move value-only information from another workbook, then created a command button and attached the code. The macro runs and works, but when the button is pressed I get an error 1004 Select method of range class failed. The debug stopped on the fourth line of the code:

Range("A15").Select
Windows("GWS Extractor (V8).xls").Activate
Sheets("Raw Data Transfer").Select
Range("A16:BW10015").Select
Selection.Copy
Windows("GWS Analyzer.xls").Activate
Sheets("Database Transfer").Select
Range("A16").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

Any clues to the problem? Both workbooks are open. The full code has multiple rehashes of the same basic code, pulling from different locations and placing in different locations.

You can shorten that code to simply:

Please Login or Register  to view this content.

Whizbang,

Yeah, Im sure the macro recorder code is pretty clumsy, since it only knows what each keystroke wants to do, not what the full intent is. I will make the sub and give this a try.

Thanks