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)
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
Microsoft ExcelSpreadsheetsVBA
Last Comment
pfmurray
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Whilst both solutions may have worked with more effort and understanding the underlying issues weren't resolved and time was of the essence