I wish to convert the following spreadsheet formula to one calculated in VBA.
The problem I'm having is replicating the "Indirect(b2)" piece of the formula in VBA. I keep getting Error 1004. Does anyone have the right syntax for this? I've been searching a while but can't find anything that works.