Looping through and deleting rows

[Mim]

I need to write a macro that will select a range of cells (number of rows
always different). Then look into Column C in each row in the selection, and
delete the entire row if the text in that cell is not "Y".
Then it needs to move onto the next row, until all rows in the selection are
looked at.
I know this should be easy enough, but I can't seem to get the correct
syntax for the statement "for each row in current selection"
Help, please !
Thanks,
MIM

 

[Ken Snell \(MVP\)]

Sounds as if your question pertains to EXCEL? This newsgroup is for ACCESS;
I recommend that you post your question in an EXCEL newsgroup.