Filtering Data

[nitzbar]

I'd like to filter out some data in a spreadsheet before running a macro and have a couple of questions.

1. What is the syntax I could use in a loop to only consider values within 2 times ( e.g., i tried the equivalent of > 08:00:00, but that did not work )

2. Is there any way I can get my macro to delete rows where there is redundant data?

Thanks..

[Bob Phillips]

Untested



If cell.Value >= TimeSerial(8,0,0) And cell.Value < TimeSerial (9,0,0) Then

...

[TheAntiGates]

And on the line you first were following,
cell.Value >= #8:00:00 AM#