How to Make a Macro to filter then reset all the rows
Hello
I'm trying hard to make this macro work, but i keep failing.
This is why i ask for you guys help, probably you are smarter than me.
This is the basic problem:
1, I want to make this button Hide all the rows which don't contain data in this column. (other columns stay there just become empty as the filter applies)
3, This i want to make as a reset button, to reset the view.
Please take a look at my problem, and help me solve it, i would be really thankful
excelhelp.jpg
Hi
Try these.
Please Login or Register to view this content.Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
wow, thanks for the quick reply, looks like you made my day, Its working!
Only one thing is missing from my script and its done.
Could you? im really not good in excelling
The "Unhide" only makes the row E visible again but its possible that im hiding the other rows 2, but it bring back only E
Ok. E is a column. Not a row. So first macro hides ALL rows that in column E the speccific rows are without values.
The unhide does the opposite!
So not able to follow you. Perhaps if you'll explain a little more..
okay my mistake
So i changed your script to apply for more columns. there is E F G H +unhide
If i click F than unhide, it does not bring it back.
i tried to put:
If .Range("E:H" & i).Value = "" Then
it does not unhide everything
hope you understand me
Apologize for the delay but still not sure about your request..Do you mean?
Please Login or Register to view this content.
Worked out great. Its working like a charm. Thanks. you're the man!!! :D
One more little thing:
What is the opposite of: Cells.Select ?
Cells.unselect aint working
the cells are still selected after running this command
Try in this way(as there is not exactly the option unselect).
Please Login or Register to view this content.
All my problems [SOLVED] !!! Thank you Fotis!
You are welcome and thanks for the feedback.
As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.
Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks