DESPERATELY NEEDING HELP! "Range Class" method failing!

Posted by Twood on November 01, 2001 5:09 AM

Hi,
I have a macro which takes cells from one worksheet and inserts them into another worksheet. However, it always breaks execution at the point where I am selecting the range in the destination sheet for pasting. What is alarming is that this happens even in code for a recorded macro.... it always breaks at the same point. ANY help at all would be GREATLY appreciated. Thanks.

Posted by Jerid on November 01, 2001 5:17 AM

Try adding the word application to your line of code.

Example:
application.range("A1").select

Jerid

Posted by TWood on November 01, 2001 7:09 AM

Re: DESPERATELY NEEDING HELP!

THANKS!!
For future reference though, can you tell me when and why you use this?

Posted by Jerid on November 01, 2001 1:05 PM

Re: DESPERATELY NEEDING HELP!

I use it whenever I have more then one workbook open at the same time. I don't know why, just that if I don't I get that error.

Take care.