Hi Heather,
Highlight the range to be copiedF5SpecialVisible cells only
HTH

"heatherB" wrote:

i have an excel doc. that has hdden and unhidden information. i want to
copy and paste ONLY the unhidden information. When i copy and paste it it
takes everything hidden with it. how to i stop that from happening.?