User input as a range. What am I doing wrong?
 

Well, apparently, VBA gives this error mesage only when one spicifi
file is open. When this file is open, the code is not working even i
it was working before. As soon as I close this ONE file, everythin
goes back to normal.
NOTE: I don't have any wokbook open declarations, but I do have Chang
& Double click Declarations in the worksheets. I also have a lot o
Publics in in it. Could that be the cause?

Thanks.
Irad

--
Irada Shamilov
-----------------------------------------------------------------------
Irada Shamilova's Profile: http://www.excelforum.com/member.php...fo&userid=1228
View this thread: http://www.excelforum.com/showthread.php?threadid=27209