Add formula thru VBA

[rizmomin]

Hello:

I am using below VBA code successfully.

Please Login or Register  to view this content.

I want to add the formula in the next row : =IF($Ax=$K$40,$L$19,0)
where x in $Ax would be 1 + the value in cell B112
Example if Cell value in B112 = 50, then the formula would be =IF($A51=$K$40,$L$19,0)

I hope this is clear and let me know if you have any questions.

Thanks

Riz

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[rizmomin]

Hi John:

Yes this works..
Thank so so much..

Riz

[JOHN H. DAVIS]

You're welcome. Glad to hear that and thanks for the feedback.

[arlu1201]

rizmomin,

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code in [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

[rizmomin]

Hello arlu201:

Sorry, i got it..this wont happen again.
Now i know how to tag the code.

Riz

[rizmomin]

Hi John:

Can you help me add 1 more formula.

Want to add

Please Login or Register  to view this content.

where x = 1 + value in cell B112

Thanks

Riz

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[rizmomin]

Hi John:

Thanks a lot for your help...it works.

Riz

[JOHN H. DAVIS]

Glad to hear and thanks for the feedback.