issue with outcome of if/then statement in VBA

**Marijke** · 02-19-2013, 09:21 AM

Hi,

I’ve got a problem with one of my if/then statements and I can’t seem to get it working. Most likely it’s an easy fix that I keep overlooking.
I've set all criteria but as outcome i do not want a fixed type of text to be populated, but a formula need to be pulled in instead.

Currently, when I run the formula, it only pull the text FALSE into the cells I have specified.
Basically, if it meets my criteria it need to pull a NETWORKDAYS formula in to column AC.

Please see attached file for details & macro.

**bob33** · 02-19-2013, 09:48 AM

If you manually enter the =NETWORKDAYS(RC[-9],RC[-6],holidays)-1 does it work correctly?

**piyushanand** · 02-19-2013, 09:49 AM

try this

Cells(i, "AC").FormulaR1C1 = "=NETWORKDAYS(RC[-9],RC[-6],holidays)"

instead of

Cells(i, "AC").Value = ActiveCell.FormulaR1C1 = "=NETWORKDAYS(RC[-9],RC[-6],holidays)"

**Cheeky Charlie** · 02-19-2013, 09:49 AM

Where you have

Please Login or Register  to view this content.

I think you want

Please Login or Register  to view this content.

At the moment the effect of line 1 is 'cells(i,AC) is equal to the outcome of the true/false statement: activecellformula = the formula outlined'
Which will very depending on which cell is active when the macro is run.

Seems to me a simple mistake to do with turning a recorded macro into a streamlined macro.