filter and macros

**mthem2003** · 08-22-2009, 09:24 PM

hello

i am using MS office2007

in summary: I am creating a macro that runs a custom filter on a column and then run a command to do some functions on the filter results

my problem:

I need some help manipulating data after I ran a custom filter.

how do i code the macro to let it run the commands ONLY on the filter results and not on the whole column

thanks

**martindwilson** · 08-22-2009, 09:39 PM

possibly copy visible cells to a spare sheet,do changes then paste them back
nope that doesnt work!
sorry

**mthem2003** · 08-22-2009, 10:15 PM

Originally Posted by martindwilson

possibly copy visible cells to a spare sheet,do changes then paste them back
nope that doesnt work!
sorry

Thanks for your response.. but if you see how many excel files I need to work on!!! thats why i need do it using a macro

**mudraker** · 08-22-2009, 11:16 PM

This cade assume data is already filtered & that colum A has entry in the last used row
Do your action where the message box code is

Sub dddd()
   Dim l4Row As Long
   
   For l4Row = 2 To Cells(Rows.Count, "a").End(xlUp).Row Step 1
      If Rows(l4Row).EntireRow.Hidden = False Then
         MsgBox "Row " & l4Row
      End If
   Next l4Row
End Sub