I want to hide many rows at the same time.
I have a column, if the row have a "x" in this column, i would like it to be marked and hided. Is there an easy way to do this?
I also want to ask, is there a way to unhide all rows at the same time?
Thank you for your help,
Do you want to do the unhiding / hiding on the click of a button or as soon as the "X" is entered?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
use a filter.
Excel 2007 => data => filter
and filter on everyting (except x)
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Perfect! Thank you oeldere!
Glad I could help. Thanks for the reply.
If the question is solved, will you mark your question as solved?
If you have (other) questions, just ask.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks