I have a macro that deletes rows in a spreadsheet if the patient's age is less than 17. [What I need the macro to do now is display a message box that tells me how many rows were deleted. I can get the macro to display a message box, but I can't get it to count the deleted rows.
Please Login or Register to view this content.
Try this:
Please Login or Register to view this content.
_________________
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 for the suggestion. However there appears to be a bug somewhere. Depending on what numbers are entered in column D, the output of the macro is either correct, yeilds an incorrect number, or yields a negative number.
See the attached worksheet
Last edited by shg; 09-10-2009 at 04:45 PM. Reason: deleted spurious quote
Take out this line of code from where it is and move it all the way up the top, under the DIMs...
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks