I am trying to write a macro that puts =Iferror at the beginning of a formula, if it is not already there. I have created a macro that almost does this. The problems is that it does not work if the selection is greater than one cell. The code is shown below. Thanks!
Please Login or Register to view this content.
Have a look at the thread below
http://www.excelforum.com/excel-prog...-formulas.html
just add your if formula hasn't iferror test
Last edited by WasWodge; 12-25-2012 at 11:04 AM.
If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved
Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown
One way:
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks