filter and macros

[mthem2003]

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]

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

[mthem2003]

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]

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

Please Login or Register  to view this content.