"Bob Phillips" wrote in message ...
I really think it would be better if you posted the code rather than
expecting us to work it out from a brief explanation.

It will probably be something to do with trying to refer to data on the
activesheet, but having selected another, but can't be more specific at this
stage.


I found the answer at an excel related web site
(http://www.j-walk.com/ss/excel/tips/tip20.htm). I need to have a
"fully qualified" reference to my range. IOW, instead of passing the
range to the macro as MyRange, I need to pass it in as
'MyWorkBookName.xls'!MyRange.

See ya,

Ken