brothertruffle880
asked on
Excel 2010 - Selecting and copying cells from areas with hidden rows is not working
I would like to select and copy cells in an area where there are hidden rows. However, every time I try to copy I wind up selecting/copying my selected cells AND hidden cells too!
I just want to copy cells that are visible.
How can I do this?
I just want to copy cells that are visible.
How can I do this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If the cells are hidden by using a filter, ie the hidden cells do not match the filter criteria, copying will only copy the visible cells anyway.
ASKER
The cells are not filtered, just a number of rows are hidden.