runtime error 1004
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 -
|