Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Carlos & Jim,
You were both right! Thank you! - that allowed me to select the required cells; however, maybe you can clear something up for me. In the code of my macro the previous line reads: ws2.Cells.Clear and I execute that command while WS1 sheet is active. Is this "need to be on the active sheet" dependent on which command you are trying to execute (it appears to be) and if so is there any publication that will tell me which command requires the sheet to be active? Normally when I write macros involving more than one sheet I try to limit the number of times that the screen flashes between the different sheets and that is what I was trying to prevent in my original lines of code. Thank you again for such a quick and accurate response - - jc - |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Runtime error 1004 | Excel Programming | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
Runtime error 1004 | Excel Programming | |||
Runtime Error '1004' | Excel Programming | |||
Runtime error 1004 | Excel Programming |