hidden rows
 

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?

hidden rows
 

f5special cellsvisible
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"pierre" wrote in message
...
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?

hidden rows
 

it worked thank you........