Copy Just UnHidden?

[Guest]

I have some data in which I have hidden some Columns and some Rows. I would
loke to copy just the visible portion into a new WS. Ctrl+A is like a love-in
at Grammercy Park -- everyone is a friend. Need to be more selective (never
know what you might catch <g>)!

 

[Don Guillett]

Select what you want to copy>f5>special>visiblecells>select where you want
to paste>paste

 

[Guest]

Than Kieu (the famouns Vietnamese patriot). I knew there was a way <g>! (Oh
yeah, and I checked -- it's Gramercy Park -- one 'm'. I'm old, I forget <g>)
--
Dave
Temping with Staffmark
in Rock Hill, SC

Select what you want to copy>f5>special>visiblecells>select where you want
to paste>paste

 

[rb]

Follow Dave's recommendations but also make sure that you don't have any
merged cells in your selection!