Connecting Tech Pros Worldwide Forums | Help | Site Map
bytes > topic > visual basic > insights

Excel: select only visible cells

Moderator
  
Join Date: Oct 2006
Location: Australia
Posts: 7,748
#1   May 11 '07
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



Newbie
  
Join Date: Feb 2008
Posts: 1
#2   Feb 13 '08

re: Excel: select only visible cells

I experienced this problem many time.
But I couldn't know the solution.
Now it is.
very thank you.
Reply

« previous insight | next insight »

Similar Visual Basic 4 / 5 / 6 bytes

/bytes/development

/bytes/it

/bytes/other

Forums
Visit our community forums for general discussions and latest on Bytes

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 229,155 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved