Select range with specified dates

[jessica]

Hello guys!

I have a excel sheet where I have 4 columns with data.
Column B contains dates. I would like to select specified
date (for exaple from input box) range. For examle
I have date 13.10.2003 on rows 30 to 400. Then I would
like to select range (A30400). How can I do it in vba
script.

Please help me,
Jessica

 

[Tom Ogilvy]

apply an autofilter to your data. Data=>Filter=>Autofilter. Select column
B and select the date of interest.

If you want a macro, turn on the macro recorder while you do it.