Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Select Error
I’m having trouble selecting a range of cells on one sheet and copyin
them to another. I’ve tried using the tried and true method o recording a macro and pasting the code to a command button where I wan it… and even this idea has failed me. Windows("AQWA002.CSV").Activate Range("B7:B9840").Select Selection.Copy Windows("0510.xls").Activate Range("C31").Select ActiveSheet.Paste I keep getting a ‘Select method of Range class failed’ error at th second line. Can somebody explain why this doesn’t work and what I need to do to fi it? Thanks -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-Time error '1004' : Select method of Range class failed | Excel Discussion (Misc queries) | |||
Error 1004, "select method of range class failed" | Excel Programming | |||
excel97: runtime error 1004 select method of range class failed | Excel Programming | |||
Run-time 1004 error on range select | Excel Programming | |||
error 1004 Select method of Range class failed | Excel Programming |