Select range with specified dates

  • Thread starter Thread starter jessica
  • Start date Start date
J

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

Please help me,
Jessica
 
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.
 
Back
Top