LinkBack URL
About LinkBacks
Good afternoon everyone,
I'm looking for VBA code that will hide a row if a cell meets a certain value.
For example, if A1 = "A", hide rows 2-5.
Good afternoon everyone,
I'm looking for VBA code that will hide a row if a cell meets a certain value.
For example, if A1 = "A", hide rows 2-5.
Last edited by Sky188; 09-25-2012 at 01:29 PM.
Hi, Sky188,
something like
Ciao,
Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
HaHoBe,
Thanks for the reply, unfortunately it doesn't seem to be working.
To elaborate a bit on what I'm trying to accomplish with more details,
I've got a checkbox that when clicked will return the value 1 or 0 in A1 using the codeAnd this code works perfectly. When a 0 is returned, I want rows 2 and 3 to be hidden, and when a 1 is returned I want rows 2 and 3 to be unhidden. I tried the codePlease Login or Register to view this content.But I'm having issues with this also. Any suggestions?Please Login or Register to view this content.
Hi, Sky188,
you could simplify your procedure to this:
It depends if you need the value from A1 anywhere else and if you want the rows just to be hidden if there is 1 in the cell. This extra procedure needs to be called as well, and maybe you try to add the hiding directly to the checkbox like:Please Login or Register to view this content.
Ciao,Please Login or Register to view this content.
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks