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