Macro for copying filtered slicers data

Learn_VBA

New Member
Joined
Oct 9, 2017
Messages
25
I had filters on a Excel sheet and had a macro which would copy across only the filtered data to another workbook.

I recently introduced slicers to the data, however the macro now copies across all the data and not just the filtered data from the slicers.
Anyone know how I an over come this?
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Worf

Well-known Member
Joined
Oct 30, 2011
Messages
3,973
An example:

Code:
Sub Act_Sheet_to_other_sheet()
Dim r As Range, dest As Worksheet, i%
Set dest = Sheets("sheet2")                                 ' destination sheet
Set r = ActiveSheet.UsedRange.SpecialCells(xlCellTypeVisible)
For i = 1 To r.Areas.Count
    r.Areas(i).Copy
    dest.Cells(dest.Range("a" & Rows.Count).End(xlUp).Row + 1, 1).PasteSpecial _
    xlPasteValues, xlNone, False, False
Next
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,100,054
Messages
5,472,200
Members
406,809
Latest member
haf19

This Week's Hot Topics

Top