Which is what I was alluding to.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Ken" wrote in message
om...
"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