Thread: Paste Special
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_2_] Sheeloo[_2_] is offline
external usenet poster
 
Posts: 364
Default Paste Special

You are welcome and thanks for your feedback.

Pl. mark the post as answered.

"SJT" wrote:

Thank you Sheelo.

"Sheeloo" wrote:

While copying do the following;

Edit-Go To-Special-Visible Cells only
Edit-Copy

Then Edit-Paste Special...

"SJT" wrote:

I have copied a range that includes a number of hidden rows. When I paste it
the hidden rows also appear. How do I suppress the hidden rows when I paste?
Thank you in advance for your assistance.