Selecting rows based on data of one column

I have a spreadsheet with a "Product" Column. In that column there is either a "Y", "N", or nothing. Is there a macro that I can use to select all the rows in which the letter N shows up in column "X"? This would be a huge help!


Example()

Column X
N
N
N
N
Y
N
Y
Y

N
Y
Y

I need to select all the rows that N shows up in. I need to select eh entire row not just the cells.

Thanks,





Matthew Trant, CFO
The Eastern Connecticut Business Consultants

Again with the selecting

Tell us what you need to happen with the Rows with N

Another thing. Your link is consider advertising. Please remove it unless you have permission from the sites Admin

VBA Noob

PM Simon Lloyd re link and ask him if it's ok

If you want to move them see link

http://www.rondebruin.nl/copy5.htm

if you want to delete them see this link
http://www.rondebruin.nl/delete.htm

To colour try something like. Changes row to red

Please Login or Register  to view this content.

VBA Noob