Hi
I want to be able to hide rows in a sheet automatically depending on if the value of a particular cell in that row = zero.
I was thinking of a bit of VBA in the worksheet. Can anyone help me with that part
Cheers
Hi
I want to be able to hide rows in a sheet automatically depending on if the value of a particular cell in that row = zero.
I was thinking of a bit of VBA in the worksheet. Can anyone help me with that part
Cheers
Does this help?(The UsedRange.Rows.Count + UsedRange.Row is in case row 1 is not used.)Please Login or Register to view this content.
To make it automatic, I'd put it in the Worksheet Change event.
Yip perfect
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks