Try doing the paste before you remove the filter.
Regards
Try doing the paste before you remove the filter.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
This macro will copy constant values from column E ... leaving behind blanks or any cell that does not have a constant
Public Sub CopyExcludeBlanks() Columns("E:E").SpecialCells(xlCellTypeConstants, 3).Copy ActiveSheet.Paste Destination:=Range("F9") Application.CutCopyMode = False End Sub
Last edited by nimrod; 04-18-2011 at 04:06 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks