Posted to microsoft.public.excel.programming

SIGE

external usenet poster

Posts: 206

Copy on visible cells only ...

Hi All,

I copy a range (5x5 cells, eg: a1:e5: Ctrl+C

I would like to paste this range on a New sheet on which column B & D
have been hidden. SO that my data appears on Column: A,C,E,F,G -5 rows
down.
The range becomes sort to say: A1:G5 (with no values in B & D-column)

Possible?

Cheers Sige

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy Visible Cells in Sheet with Merged and Hidden Cells	rtwiss	Excel Discussion (Misc queries)	5	April 25th 23 09:08 AM
copy visible cells	Sunny	Excel Worksheet Functions	1	December 29th 08 06:27 PM
Copy/Paste Visible cells only	Ashley	Excel Discussion (Misc queries)	1	October 17th 06 09:17 PM
Copy visible cells only	Nethie	Excel Discussion (Misc queries)	1	October 13th 05 09:31 PM
Copy & Paste visible cells only	Scott	Excel Programming	4	March 23rd 05 03:30 PM

All times are GMT +1. The time now is 02:07 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us