I need to calculate the percentage for the below code.
Cell AE43 gives the total count out.
Cell AE51 gives valid count.
Cell AE53 should hold the % for this.
How do i implement this sub for multiple cells without creating separate sub for each cells?
Please Login or Register to view this content.
Why not just use a regular formula, copied down?
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 know that's the simplest way. But I need this to be done in VBA
OK, can I ask why?
We have a project where we are not supposed to use formulas in the excel, instead get this done in VBA
So, kinda homework?
lol
So, kinda homework?
lol
No, lol. This is small part of a larger VBA code. Using formula for this task alone will not be good..
OK thanks for the feedback
Any help here?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks