Macro program to delete rows if its 2nd colomn start with 'F'
 

Hi, Could you please help to provide me with a macro script? In data
analysis, I would like to delete a number of rows whose 2nd colomn is
like 'F1, F2, F3, etc' Thanks a lot.

Macro program to delete rows if its 2nd colomn start with 'F'
 

I'd record a macro when I applied data|autofilter to that column.

Then filter to show the cells that begin with F.

Then delete those visible rows.

And finally remove the data|autofilter.

wrote:

Hi, Could you please help to provide me with a macro script? In data
analysis, I would like to delete a number of rows whose 2nd colomn is
like 'F1, F2, F3, etc' Thanks a lot.

--

Dave Peterson