Alright, so here goes. I have a front end formula that I'm trying to turn into vba, but I can't seem to get it to work the same way, or at all for that matter.
I have a sheet with a list of industries in column "A." Next to them, in column "B" are a list of values, we'll say $ amounts.
So, the formula I created that seemed to work was:
So, I simply tried replicating it in vba with:Please Login or Register to view this content.
where the 'vars' represent one of the above values . . . and it errors out because the curly brace isn't a recognized symbol in the excel vbe.Please Login or Register to view this content.
Any assistance you can provide me in finding a workaround for this seemingly rather simple problem is greatly appreciated.
Thank you in advance for considering helping.
I would attach a workbook, but I only have excel 2003 at home and I'm using 10 at work . . . also sorry in advance
Bookmarks