Problems copying filtered data

		Microsoft Office Forums > Microsoft Excel > Excel
Problems copying filtered data

FAQ

Thread Tools

Display Modes

09-05-2018, 03:09 PM

p45cal

Windows 10 Problems copying filtered data

Office 2016

Expert

Join Date: Apr 2014

Posts: 956

Code:

Sub blah()
ActiveSheet.Range("B1").CurrentRegion.AutoFilter 1, "M"
ActiveSheet.AutoFilter.Range.Offset(1).Columns(2).Copy Range("E2")
ActiveSheet.ShowAllData
End Sub

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Hyperlink to open another sheet in same workbook with filtered data	tarunbaweja	Excel Programming	1	03-20-2016 06:52 AM
Copy Filtered Data to new excel file s	theexpat	Excel Programming	0	02-18-2016 10:24 AM
Creating a Custom List that Updates when one of the data fields is filtered	anthrus	Excel	1	11-13-2014 11:58 PM
How to automatically sum in excel for filtered data	msi_g	Excel	2	08-05-2013 05:29 AM
Copying & Pasting to Firefox problems	mso2u	Word	2	04-07-2011 07:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:59 PM.