| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy filtered data (Values only)
The following code copies filtered data:
Set Rng = ActiveSheet.AutoFilter.Range Rng.Copy Destination:=Worksheets("Sheet2").Range("A1") but copies values and formulae. (e.g. .PasteSpecial xlPasteValues) How do I modify to the copy only the values Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Filtered Data | Excel Programming | |||
| Copy and pasting values of filtered rows | Excel Discussion (Misc queries) | |||
| Return filtered values into report worksheet based on filtered valueon the data worksheet | Excel Worksheet Functions | |||
| paste data next to filtered values | Excel Discussion (Misc queries) | |||
| Copy filtered data | Excel Discussion (Misc queries) | |||
Threaded Mode
