pfmurray
asked on
Creating a range reference in Excvel VBA from text in a spreadsheet cell.
I wish to convert the following spreadsheet formula to one calculated in VBA.
=ROUND(SUMIFS(INDIRECT(B2) ,TM1_cats, A2,TM1_mon th,G2)*100 0,0)
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.
Thanks
=ROUND(SUMIFS(INDIRECT(B2)
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.
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER