How do you copy a list without grabbing hidden rows you have filtered out?

paquirl

paquirl

Board Regular
Joined
Oct 12, 2010
Messages
226
Office Version
  1. 2016
Platform
  1. Windows
How do you copy a list without grabbing hidden rows you have filtered out?
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
Sort by date Sort by votes
VBA Code: 
.Sheet1.UsedRange.Autofilt3er 1, myCriteria
Sheet1.UsedRange.SpecialCells(xlCellTypeVisible).Copy myDestinatio
Or if cells contain formulas
Sheet1.UsedRange.SpecialCells(xlCellTypeVisible).Copy
myDestination.PasteSpecial xlPasteValues
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Solved
Offset select upwards without looping without selecting hidden cells?
2
Replies
11
Views
458
MichaelRSnow
M
N
  • Solved
Reading across a row of cells to grab only one result.
Replies
8
Views
245
Fluff
Fluff
drom
  • Solved
Count unique values for filtered column
Replies
1
Views
143
myall_blues
myall_blues
K
  • Question
Help with VB Code to copy workbook
Replies
0
Views
153
kizzie37
K
N
  • Solved
Copy paste Special values when some rows are hidden
Replies
3
Views
715
Akuini
Akuini

Forum statistics

Threads
1,214,924
Messages
6,122,294
Members
449,077
Latest member
Rkmenon

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top