Thread
:
Macro program to delete rows if its 2nd colomn start with 'F'
View Single Post
#
2
Posted to microsoft.public.excel.programming
Dave Peterson
external usenet poster
Posts: 35,218
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
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson