delete for multi sheets

[hudson andrew]

Hi all,

I have code that filters the data and delete the unwanted “R” .

It is currently doing that activity for one sheet"Andrew", but I wanted that to be done for more than 1 for the sheets “Andrew”, “sam”,”Dam”,”Tam”,”Kam”

Please Login or Register  to view this content.

can some one help

[mohadin]

Hi,

May try this

Please Login or Register  to view this content.

[maras_mak]

Test something like that.

Please Login or Register  to view this content.

[Fluff13]

Another option

Please Login or Register  to view this content.

[hudson andrew]

Thanks guys it really worked like a charm and is there a way I can set a dynamic range for columns .currently it is hardcoded , I wanted it to be dynamic range for columns

Please Login or Register  to view this content.

[Fluff13]

If filtering just col A, there is no need for a dynamic range, you can just use

Please Login or Register  to view this content.

as long as you have no blank rows/columns it should filter the entire data.