Cell Error Markers
Is there a better way to remove cell error markers. This works but seems
long winded.
Set tbl = Range("H2:H203")
For Each rng In tbl
rng.Errors.Item(xlNumberAsText).Ignore = True
Next
This doesn't work:
Range("H2:H203").Errors.Item(xlNumberAsText).Ignor e = True
T.I.A.
Geoff
|