LinkBack URL
About LinkBacks
Hello,
I need help with this macro to hide rows that have zero values. This macro worked for over 8 months. Now it is giving me error and I cannot figure out the issue. Please help!
Please Login or Register to view this content.
Suppress rows with zero
Hello,
I need help with this macro to hide rows that have zero values. This macro worked for over 8 months. Now it is giving me error and I cannot figure out the issue. Please help!
Please Login or Register to view this content.
What's the error message? Could it be that it's trying to hide an already hidden row?
Tim
Never stop learning!
<--- please consider *-ing !
Hi noorie,
Click on some of those values that you think should be hidden in column X and see if they really are true zero. Many times you have the format set to zero but the real number is something like .001 which displays as zero but isn't.
One test is worth a thousand opinions.
Hi, Thank you for replying.
First I unhide all rows then I run the macro. in column X i have the formula to round and make values absolute.
When the macro starts, it hides a couple of rows then the error is:
Code execution has been interrupted.
Options: Continue / End / Debug / Help
Tbh, I'd suggest posting a cut-down version of your file so we can see what's happening.
Tim
Last edited by harrisonland; 05-18-2020 at 03:49 PM.
Hi,
Macro seems to be working now. I kept on clicking continue for a few rows then the macro continued working. I'm thinking it is the data in those few rows i need to check.
Glad you got it working in the end.
Don't forget to mark the thread [SOLVED] using the thread tools at the top of the page.
You can also leave feedback for anyone who's helped by clicking the * to the left of the users' posts if you wish.
Tim
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks