Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selection.EntireRow - Filtered
Hi,
I am trying to copy (selected) filtered data from one sheet to another. Previously I have used Selection.EntireRow which copies a selection of filtered rows. I now need to just copy from Column C to Column AO - Not the EntireRow - With only the rows that i select. I have been using this... Set serng = Selection.EntireRow serng.Copy ActiveSheet.Range("A2").Select Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _ xlNone, SkipBlanks:=False, Transpose:=False But I ultimately only want it to copy from Column C and skip A & B. How do I just copy partial rows? Thanks, Bam |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selection.EntireRow.AutoFit | Excel Programming | |||
Selection EntireRow Insert | Excel Programming | |||
Autofilter - delete filtered selection | Excel Programming | |||
Sum only filtered selection | Excel Discussion (Misc queries) | |||
Filtered data selection using vba | Excel Programming |