Copying Rows when hiding other rows

N

Neutron1871

Every time I hide rows in excel and go to copy the visible rows, the hidden
rows also get copied. How do I copy the visible rows without copying the
hidden rows?
 
K

Ken Wright

Select the data and do Edit / Go To / Special / Visible cells only, then do your
copy.
 
D

Don Guillett

manually have a look at f5 goto special visiblecells or in a macro
specialcells(xlcelltypevisible)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Dealing with a Pivot Table (when I don't want to) 0
sqlite-odbc write conflict 2
Indenting every other paragraph in Word at the same time? 0
Repeating a row other than the 1st row as the header row in a table from next page 1
Copy addition formula of non-consecutive horizontal cells 2
Hide columns based on row values 2
hidden rows, column copy-paste 0

Top