Sorry guys, just realized my error. I was using a value that lookslike a cell reference. The variable LocCode was sometimes beingassigned the value "AL01" which Excel interprets as a range.Thanks for everyone's help!