Cell Error Markers

Geoff

Guest

Posts: n/a

13th Feb 2008

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).Ignore = True

T.I.A.

Geoff

« Listing installed COM add-ins | Range is nothing »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
cell colour change when set markers are reached	balding rapidly!	Microsoft Excel New Users	2	17th Jul 2009 05:28 PM
How do I put error bars in front of markers in an excel chart?	=?Utf-8?B?c3JzaGFo?=	Microsoft Excel Charting	1	17th Oct 2007 08:57 AM
Too many markers on line chart makes it a thick line and individual markers cannot be seen	denzel	Microsoft Excel Misc	2	2nd Aug 2006 04:06 PM
Given a range of cells, some of which contain errors (e.g. #DIV/0), replace each cell having an error with the value of a non-error precedent cell	Barclay0x00	Microsoft Excel Programming	3	24th Oct 2005 05:12 PM
Pasting Word table cell with paragraph markers into single Excel c	=?Utf-8?B?U3RldmU=?=	Microsoft Excel Misc	1	16th Jun 2005 11:26 PM