Deleting rows

[exocet.am39]

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]

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.

 

[exocet.am39]

thank you.