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

Hi Dave

Upon further examinations on other files I decided that
I have a problem with letter " i ". Funny but true.
Again on below code same error msg appeared.

With Worksheets("costtabletour3").Range("g2:i1000").Val idation

I have twice reinstalled xp' but no avail.
Only few days ago I had no such problem but now I am changing all "i"s
to " I ".

Thanks