View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Geoff Geoff is offline
external usenet poster
 
Posts: 371
Default 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