Translate formula to VBA code please :)

**galvinpaddy** · 08-06-2015, 05:12 AM

Good morning all,

Would someone be kind enough to take my two formula's below and translate them to what it would be in VBA?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Kind Regards

Rich

**Marc L** · 08-06-2015, 05:16 AM

Hi,

using Evaluate method, the formula is the same, see in VBA inner help …

**Andy Pope** · 08-06-2015, 05:22 AM

you mean something like this?

Please Login or Register  to view this content.

**galvinpaddy** · 08-06-2015, 05:32 AM

thanks for the responses.
I really should have been a little more thorough lol.
Already have a boat load of VBA in my sheet, basically it tracks the days picks/stock moves/replens etc.
When i started this workbook there was a formula in every cell, the formula for one section looked like:

Please Login or Register  to view this content.

After going through this forum the formulas were taken out of the sheet and put into VBA instead, it ended up like:

Please Login or Register  to view this content.

Sorry, i was asking the forum to guess what i was already working with - lesson learned.

Does that help you to help me a little more?

Regards
Rich

**Andy Pope** · 08-06-2015, 05:41 AM

not really.

if you have that code what is it you want? I'm assuming you can simply make the replace of range references, the only complicated issue us the double quotes within quotes.