Looping through and deleting rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Sounds as if your question pertains to EXCEL? This newsgroup is for ACCESS;
I recommend that you post your question in an EXCEL newsgroup.
 
Back
Top