Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a table of data in Sheet("Stepdown"). It has already been
autofiltered. I want to change all the autofiltered data in column T to "a". Here is what I have (but it changes the filtered and autofiltered data to "a"). Sheets("Stepdown").Range("T1").Select Selection.End(xlDown).Select ActiveCell.FormulaR1C1 = "a" ActiveCell.Copy Range(Selection, Selection.End(xlUp)).Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False -- Thanks Shawn |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Autofilter - copy & paste | Excel Worksheet Functions | |||
Copy/Paste in Autofilter | Excel Discussion (Misc queries) | |||
Sort, Copy, Paste..without Autofilter..Anyone??? | Excel Worksheet Functions | |||
How do you paste data when autofilter is on? | Excel Discussion (Misc queries) | |||
AUTOFILTER copy and paste | Excel Programming |