hidden rows

P

pierre

hello everyone

i have some data from A1 to A20
but i have hidden the following rows : A3 to A9
and now i would like to copy the remaining data which are A1,A2,A10 to A20
to another sheet..but i cant do that...excel keeps copying everything...
what to do?
 

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

How to delete ALL cells containing the same data 0
How to delete ALL cells containing the same data --- REVISED 0
Drop down list control value in vba 2
Copy data from unlocked cells 3
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
Rearranging DATA 6
combining two rows of data into one (Not Concatenate) 1
Pasting a cell into bookmarked table from excel vba 1

Top