how do i paste rows/columns avoiding hidden rows/columns

B

Billy Liddel

Two stages

Edit, Goto, Special, Current Region

Edit, Goto, Special, Visible

Then copy and paste asw normal.

Regards
Peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Need Help with a VBA subroutine 0
hidden rows, column copy-paste 0
Format column widths from one table to a separate table on same page 1
Copy/Paste with Hidden Rows/Columns Excel 2007 3
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Copying Rows with values in column A pasting in a new doccument and saving that doc 1
copying one column with hidden/filtered rows to another colum 2

Top