Thread: Deleting rows
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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