Thread
:
Deleting rows
View Single Post
#
2
Posted to microsoft.public.excel.programming
Dave Peterson
external usenet poster
Posts: 35,218
Deleting rows
You could record a macro when you:
Select column B
filter to show the 1's
delete the visible rows
remove the autofilter.
Stop recording.
wrote:
Hi,
I'm new to macro programming. In colum B, I have 0's and 1's. How can
I write a simple macro to delete all rows containing 1's?
thank you!
d b
--
Dave Peterson
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson