View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shawn Shawn is offline
external usenet poster
 
Posts: 271
Default Autofilter and Copy and Paste

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