LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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/

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Select Month, get the dates Gaurav[_5_] Excel Worksheet Functions 2 May 7th 10 07:31 PM
How can change range to select active rows instead of :=Range("S10 ldiaz Excel Discussion (Misc queries) 7 August 29th 08 03:52 PM
When entering data into a range of cells, select the entire range. Q Excel Discussion (Misc queries) 0 September 26th 07 04:36 AM
Select a range of data dependant on the users input ie dates Rachel[_2_] Excel Discussion (Misc queries) 2 May 6th 07 06:46 PM
How do I select from within a range of dates? Joe Leon Excel Discussion (Misc queries) 2 February 12th 06 02:41 PM


All times are GMT +1. The time now is 12:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"