Hi Guys,
I am using the following code to get an automatic sum, and it's working great!
However, Column M has some #NA values and thus my returning sum is #NA.
Is there a way to modify the macro in such a way that it either ignores the #NA or make it equal to 0?
thanks for your help!
Please Login or Register to view this content.
Last edited by nawGo; 03-07-2014 at 05:17 PM.
try this
Please Login or Register to view this content.
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
Hi Ernest,
Thanks however, it's not working as I am just getting "-" for the total sum!
Your title said macro, your question is about macros, but you posted in the general forum? I will move it to the VBA forum for you
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I beleive that should have worked....can you upload a small portion of the file so I can see what is going on?
Hi Ernest,
Attached is a sample excel sheet. Let me know what I am doing wrong, Thanks!
give this a try
Please Login or Register to view this content.
Thankss!! :d
Glad I could ....sorry I pointed you in the wrong direction to start....thanks for the rep point...have a great day
not to mention and you deserved it!
Have a good weekend!
thanks...you too
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks