I've had some problems with .clearcontents when the area contained merged cells.

Any chance?

wrote:

On Jun 2, 8:51 pm, Dave Peterson wrote:
Your problem may have gone away, but this was not the solution.

VBA doesn't care if your range address was in upper/lower/mixed case.

Hi Dave

But I didn't have any problem at all in the first place.
It was like finding your donkey after loosing.
I'd be so pleased if I know what the problem was.

Thanks

--

Dave Peterson