ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Cell Error Markers (https://www.excelbanter.com/excel-programming/406051-cell-error-markers.html)

Geoff

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


All times are GMT +1. The time now is 12:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com