Sounds like your manual method is about the quickest without using VBA.

Have you tried using the macro recorder to see what code you get?


Gord Dibben MS Excel MVP

On Wed, 20 May 2009 08:05:01 -0700, Craig
wrote:

Hi

I have a big Excel list with a header row

Right now, I do a filter on two of the columns to display only rows that
meet both criteria. Then I do an Edit, Replace command twice...once to
replace all the values in one of the columns with some other value, then
another Edit Replace to replace all the values in another of the columns with
some other value. Then I remove the filter to get all records shown...but
this takes time...

is there a quicker way to do this or do I need to create a macro??

Thank you

Craig