Selecting cells
Hi everyone!
I have a filtered list of more than 1500 rows, so that about 200 rows are shown. Now I want to make a diagram, using just the visible rows. Problem is, that the rows aren't neighbouring and I don't want to select every single row. Is there a key or combination I have to press while selecting the first and the last of the rows, so that only the visible ones are selected?
Btw, nice weekend everybody!
Hi and welcome to the forum
If this is a once-off, just copy the filtered list and paste it somewhere else, and work on the copy
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Perfect, that's working fine! Except that excel is crashing nowbut gladly I can fix that (I think)
Thanks! I will try that immediately, hopefully I don't make it worse
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
donroberto 
Register To Reply
Bookmarks