Formulas, Convert to VBA Script

[jrwrita]

Hi all,

I have a bunch of repetitive formulas I use in my sheets.

For example, I place this formula in column EE:2 on sheet "database". I dont want the formula in any of the cells as I have to do other stuff in the cells that this would normally return a #N/A. So I just want to place the result of the below vlookup in the cells that it applies too.

Can anyone help me form this into a vba code? I have about 16 of these, from EE:ET.

IF(AND(OR($BM:$BM="Equity|Public",$BM:$BM="Equity|Private",$BM:$BM="Pref Shares"),$BN:$BN<>"Excel",$BN:$BN<>"ITS"),$AT:$AT*(IFNA(VLOOKUP(EE$1&$S:$S,EQ_Shocks!E:F,2,FALSE),VLOOKUP(EE$1&"OTHERS",EQ_Shocks!E:F,2,FALSE))-1),"")

Any help would be appreciated, Thanks.

 

[Michael M]

which cells does it apply to ?
You could also adapt the formula to not show anything if the result would be N/A, so....

I think we need more information !!!

 

[jrwrita]

Applies to the whole of column EE2:EE6000. but all my formulas apply to the full range would be EE2:ET6000.

 

[Michael M]

So I asked

which cells does it apply to ?

in response to this statement

I dont want the formula in any of the cells as I have to do other stuff in the cells that this would normally return a #N/A.

 

[jrwrita]

Sorry, it applies to the conditions in the formulas.
ie if in column BM = Equity Private , etc then write to EE2, loop through each row.