How to Remove the Green Error Arrows for an Entire Sheet with VBA
Dear Forum,
While making copies of SHeets as Values and keeping the formats, I am getting some cells with those irritating green arrows showing some errors when a Number is stored as Text...
It will be quite cumbersome to manually edit or Ignore each cell?
Is there a way of Programmatically Ignoring these errors by a VBA code where I can provide Range or the entire Sheet..
Warm Regards
e4excel
Last edited by e4excel; 04-17-2011 at 03:08 PM.
will clear the numbers as text flag from every workbook and make no more.
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
This works too...
Thanks a lot Mike...
Just have to add this line of the code in the loop while the New WorkBook is being created and what about the Parent WorkSheet ? If I have to ignore these Errors in the PArent WorkSheet where do I add the code?
Warm Regards
e4excel
The error triangles are an application level occurance. If they are on for one worksheet, they are on for all workbooks. If off for one, off for all.
Thanks Mike..
I thought as much after Adding the code all the Arrows irrepective of the Parent _ Child Sheets Dissappeared..
Thanks a lot...
Just wanted to confirm as did not know for sure..!
Warm Regards
E4excel
Great tip.
Dear Mods,
I am unable to mark this as SOLVED as no option available..
Kindly Mark it ..
Warm regards
e4excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks