Hi,
I am trying to figure out a Sub, that allows me to make visible/invisible a whole row, depending on the entry in Cell A(n). However, the Sub makes all rows invisible, independent of the value in A(n). Who can identify my mistake?
Thanks in advance!
Please Login or Register to view this content.
Do you perhaps want:
I'm assuming you're altering visibility based on value of A in each row being iterated rather than just the value in the last row (as is taking place in your original code)Please Login or Register to view this content.
If so why not just use an Auto Filter ?
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
If you are trying to test the value A then it needs to be in quotes.
Currently, without the quotes, it is being treated as a variable.
Do you not also require code to unhide a row if the test fails? As DO has included in his code.Please Login or Register to view this content.
Thanks for your help guys, I indeed used an AutoFilter now, it's a lot easier
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks