Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select Month, get the dates | Excel Worksheet Functions | |||
How can change range to select active rows instead of :=Range("S10 | Excel Discussion (Misc queries) | |||
When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
Select a range of data dependant on the users input ie dates | Excel Discussion (Misc queries) | |||
How do I select from within a range of dates? | Excel Discussion (Misc queries) |