deleting highlighted cells
Posted by Moomal Abro on July 03, 2001 3:11 AM
I have a file, in which I have writting some VBA to highlight certain cells. I now need to delete all the records that do not contain highlighted cells. In other words:
In column A, I have used VBA to highlight certain cells. There is other information in other columns, but only column A has highlighted information. I now need to go through the records and, in column A, find the cells that are not highlighted, and delete the entire row containing an unhighlighted A cell.
I'm sure this must be very easy to do, but unfortunately my knowledge of VBA is extremely limited.