LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Copy Visible Cells in Sheet with Merged and Hidden Cells

How do you copy only visible cells on a sheet that has merged and hidden
cells. Not as easy as everyone thinks. I keep getting the error message
stating " Cannot change part of a merged cell." Any suggestions? This isn't
a simple ctrl c......ctrl v. I've tried special select of visible cells and
copy and got the error stated above.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Copying visible merged cells rtwiss Excel Discussion (Misc queries) 2 October 1st 08 08:15 PM
Data is not visible in merged and wrapped cells akmac Excel Worksheet Functions 1 July 31st 07 09:16 PM
Copy/Paste Visible cells only Ashley Excel Discussion (Misc queries) 1 October 17th 06 09:17 PM
Excel: copy and paste only shown not hidden cells into new sheet MU Excel Discussion (Misc queries) 1 February 6th 06 10:31 PM
Copy visible cells only Nethie Excel Discussion (Misc queries) 1 October 13th 05 09:31 PM


All times are GMT +1. The time now is 01:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"