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.