Hello:
I need a VB Macro to copy the below formula in cell R214 to R606
=IF(ISERROR(Q214/P214),"0",Q214/P214)
So formula in
R214 =IF(ISERROR(Q214/P214),"0",Q214/P214)
R215 =IF(ISERROR(Q215/P215),"0",Q215/P215)
R216 =IF(ISERROR(Q216/P216),"0",Q216/P216)and so on..
Let me know if any questions and thanks for the help.
Riz
Last edited by rizmomin; 03-24-2013 at 10:51 AM.
Try this.
Range("R214:R606").Formula = "=IF(ISERROR(Q214/P214),0,Q214/P214)"
If posting code please use code tags, see here.
Post deleted - pls ignore
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Hi Notie:
Thanks a lot...this will work for me
Riz
Riz
No problem.
Note, I removed the "" around the 0.
If you really want them you can use this.
That will give you text though which could interfere with other formulas.Range("R214:R606").Formula = "=IF(ISERROR(Q214/P214),""0"",Q214/P214)"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
rizmomin 
Register To Reply
Bookmarks