VB Code to add Formula in Cell

**rizmomin** · 03-24-2013, 10:37 AM

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

Please Login or Register  to view this content.

R214 =IF(ISERROR(Q214/P214),"0",Q214/P214)
R215 =IF(ISERROR(Q215/P215),"0",Q215/P215)
R216 =IF(ISERROR(Q216/P216),"0",Q216/P216)

Please Login or Register  to view this content.

and so on..

Let me know if any questions and thanks for the help.

Riz

**Norie** · 03-24-2013, 10:46 AM

Try this.

Please Login or Register  to view this content.

**Special-K** · 03-24-2013, 10:48 AM

Post deleted - pls ignore

**rizmomin** · 03-24-2013, 10:51 AM

Hi Notie:

Thanks a lot...this will work for me

Riz

**Norie** · 03-24-2013, 10:54 AM

Riz

No problem.

Note, I removed the "" around the 0.

If you really want them you can use this.

Please Login or Register  to view this content.

That will give you text though which could interfere with other formulas.

Re: VB Code to add Formula in Cell