View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Selecting rows with dates equal to or later

Hi Evil.

Perhaps, consider using Excel's Autofilter.

If you are not familiar with this feature, see
Debra Dalgleish's tutorial at:

Excel -- Filters -- AutoFilter Basics
http://www.contextures.com/xlautofilter01.html

If you need to automate this process, try turning
on the macro recorder while you perform the
requisite steps manully; the resultant code may be
edited to render it more generic.

If you experience problems with such editing,
post back with specific details.


---
Regards,
Norman


"Evil Bumblebee" wrote in message
...
Hi All,

I have dates in a row, in a named range.

In that range, I want to select all the rows with dates equal to or
later than 06/30/06.

Please help.

E.B.