View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
[email protected] sweetpotatop@yahoo.com is offline
external usenet poster
 
Posts: 5
Default searching for a time range in Excel

On Jun 13, 11:31*am, "edvwvw via OfficeKB.com" <u42512@uwe wrote:
wrote:
Hi,


[quoted text clipped - 34 lines]


- Show quoted text -


Thank you very much, now I have another question, how do I loop
through all these highlighted items, as I have further investigation
on these items.


It depends what you want to do - if you want to make anamenment to the times
then the macro will need to be written in a different way.

I haven't got time today to look at it for you - maybe someone else will help

edveve

--
Message posted viahttp://www.officekb.com


Once I filtered all the "times", I then have to look into other
columns. But I might still need to look at rows before or after the
3am or 6am frame.

So that's why I need to see all rows, but have the ability to loop
thru only the filtered rows and refer to other rows before or after
the filtered ones