Hi All,
I have one code column, Codes are like A03-01, A03-02 and so on. When i pass this in Sumifs Formula in VBA, A03-01 code becomes A3-1 and A3 is treated as range.
Please help me to understand, how can i pass A03-01 as string in the VBA Formulas.
Should be This: "=SUMIFS(Sum_Range,Criteria_Range,A03-01)"
But Become: "=SUMIFS(Sum_Range,Criteria_Range,A3-1)"
now A3 becomes Cell Adddress.
Thanks in Advance!
maybe wrap the A01-03 in double Quotes?....you might have to play with the double double quotes because of being in VBA....
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
Text strings go between double quotes.
=SUMIFS(Sum_Range,Criteria_Range, "A03-01")
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks judgeh59, its is helpfull.
excellent - glad we could help...
If this has been completed to your satisfaction, please set the thread to Solved...If you feel we deserve an increase in our reputation, feel free to click on the star in the lower left of the thread. Remember, someday when you help somebody they may add to your rep points, and it could be us...just a thought...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks