Visual Basic for Excel

[CESCOBAR]

I have a series of swipe card "beeps" in excel 2010 for the month of april. They are sorted by date per each employee. There are multiple "beeps" per day since the employees go from the production floor to the cafeteria, home, or to the restroom

I need to device a macro where I can calculate the time outside of the production floor that each employee takes. I'm having problems with Visual Basic since I do not know how to tell visual basic to select a range that I need to delete after filtering. This range shows directly under the filtering header after filtering; however, in cell referencing related terms there are more rows in between but are hidden due to filtering.

I need to know how to select this range and delete it after each filter (because I need to filter many times by different dates) without assigning a cell reference like (G24:J24) since this will change month to month.

Thank you.

 

[L. Howard]

Maybe a revised range version along with the .SpecialCells(xlCellTypeVisible) cells can do the trick for you.

Delete or clear...?

Howard

For Each cell In Range("A2", Range("A2").End(xlDown)).SpecialCells(xlCellTypeVisible)
cell.EntireRow.Delete
'cell.ClearContents
Next