Select range with specified dates
 

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 (A30:D400). How can I do it in vba
script.

Please help me,
Jessica



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Select range with specified dates
 

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.

--
Regards,
Tom Ogilvy



"jessica" wrote in message
...
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 (A30:D400). How can I do it in vba
script.

Please help me,
Jessica



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/