Hi Tempy,

I could reproduce your situation if I added a cell outside the existing
used range, formatted the cell and then deleted a cell (or cleared its
contents) .

I found that adding the line:

Set dummyRng = .UsedRange

immediately before the End With line at the foot of the macro obviated the
problem.


---
Regards,
Norman


"Tempy" wrote in message
...
Hi Norman,

In cell x101 is 0 and in formula bar with x100 selected blank

Les Stout

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!