Formula to VBA

[gan_xl]

Hi Team,

I need your help to convert this formula into VBA code.

Please Login or Register  to view this content.

Thanks

[Fotis1991]

Excel has an excellent tool for this, calling Macro Recorder.

[jeremyfox36]

Or try this. I'm afraid I've forgotten who wrote it (it wasn't me) but I've found it really handy.

Please Login or Register  to view this content.

[zbor]

Or just:

Please Login or Register  to view this content.

[jeremyfox36]

wow - I never knew about Evaluate!
Apparently you could also just use this (I think):

Please Login or Register  to view this content.

Got it from here: http://www.ozgrid.com/forum/showthread.php?t=52372

[gan_xl]

Thanks All.
I am getting error while converting the above code using arguments. Kindly let me know if you find out the error.

Please Login or Register  to view this content.

[jeremyfox36]

Are you trying to insert the formula in the cell or the result of the formula into the cell? It looks to me like you're trying to insert the formula into the cell.

Use this to insert the formula:

Please Login or Register  to view this content.

Use this to insert the result:

Please Login or Register  to view this content.