By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,368 Members | 2,755 Online
Bytes IT Community
Submit an Article
Got Smarts?
Share your bits of IT knowledge by writing an article on Bytes.

Excel: select only visible cells

Expert 5K+
P: 8,434
If you have applied filtering to your worksheet in Excel, a normal copy/paste operation will include the cells which are currently hidden. This can be a major hassle.

To select only the visible cells, you can use this technique, posted by member alanlawlor in response to a question in the VB forum...
Expand|Select|Wrap|Line Numbers
  1. Selection.SpecialCells(xlCellTypeVisible).Select
  2. Selection.Copy
May 11 '07 #1
Share this Article
Share on Google+
1 Comment


P: 1
I experienced this problem many time.
But I couldn't know the solution.
Now it is.
very thank you.
Feb 13 '08 #2