![]() |
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