It works if all I want to do is view those rows only, but I have other rows
that need to remain in place. I was hoping for a simple fix.
--
Tracy


"Glenn" wrote:

Tracy wrote:
O.k I copied and pasted the information and then closed the application. The
MS Visual Basic is still on my task bar. The Column is "B" and I have two
choices to input, either 1 or 0. My spreadsheet is over 3000 rows long and I
need to view only the rows which contain the 1. Does the code automatically
work or do I have to do something else?


Have you considered using an AutoFilter? Not automatic, but fairly simple to
select only rows with a 1 in a certain column.