Convert Excel formula into VBA code

**Grumpy9215** · 05-10-2012, 03:42 PM

I have an Excel formula I'm having trouble converting into a VBA code.

Please Login or Register  to view this content.

Thanks for your assistance.

**tigeravatar** · 05-10-2012, 04:08 PM

Grumpy9215,

You can use the formula directly with the Evaluate method:

Please Login or Register  to view this content.

However, if you want code to repeat the steps the formula is taking, it would look something like this:

Please Login or Register  to view this content.

**Leith Ross** · 05-10-2012, 04:11 PM

Hello Grumpy9215,

This code is untested but should work. However, there is no error handling added to this. Try it out and let me know the results.

Please Login or Register  to view this content.

**Grumpy9215** · 05-14-2012, 10:47 AM

Thank you for your assisatnce.

**palioli** · 08-20-2017, 04:37 AM

sorry, thank you

**AliGW** · 08-20-2017, 04:40 AM

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.