macro to filter a range that has text

Hi Gurus,

I have a column "B" with both numbers and text ...

i need to filter the cells that has any text and the respective row has to be deleted...

please help me with a macro

Can you upload a sample workbook showing what you are trying to do?

JimBobBowie

hi,

find attached sample and pls note that if any cell with any text in the range, the respective row has to be deleted...

If you add a helper column you could use a formula to test the data and filter on the result. This formula returns TRUE for all numbers (even if entered as text) and FALSE for text. You will need to adjust it to look at your first row of data and then copy it down. I have used row 5.

Please Login or Register  to view this content.

JimBobBowie

Try this code. It work OK for me.

Please Login or Register  to view this content.

JimBobBowie

works fine... can u please add the comment for each line of the code.....please

Hi, I have added comment to each line. Hop this helps.

Please Login or Register  to view this content.

JimBobBowie

Thanks so much