Hi,if my excel file data in column a:h, and in column a is date data in every day. i try to know how to write vba code in the case of selection data by the date, that i want to select for any propose (copy or printing). eg. date data "dd/mm/yyyy" when i put it to input box
thank
Your requirement is unclear to me.
If Col A only has date's then select Col A up to use range ??
To check for date try IsDate e.g
VBA Noob
Please Login or Register to view this content.
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
sorry,VBA Noob
i mean my selection range a:h depend on the date i do, if i want to copy data the a:h of the date 12/9/2008 my selection range is (a19:h23 )the green area of my example . or if i key in 02/9/2008 in the input box the selection area will be a6:h8 etc.
thank for your help
Why not enter the date you want in a cell (K1) and then use conditional formatting
Note Select Cols A to H first=$A1=$K$1
VBA Noob
Perhaps AutoFilter will do what you want.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Hi,i try to use autofilter to serch data that i want and then copy to sheet2, but i can not do . any one can help me why it not working,please
Example on site if you search
Links should also help
http://www.ozgrid.com/VBA/autofilter-vba-dates.htm
http://www.rondebruin.nl/copy5.htm
VBA Noob
Thank,VBA Noob
your links,help me more. now I can do it. date format is the problem.
thank,for your response
What's problem you having. Post a sample file with the code you have so fardate format is the problem
VBA Noob
I change by add some code ...Dim a AS Date
and j1 is the date format as data date in sheet1
Seem to work ok.
Could amend to
VBA NoobPlease Login or Register to view this content.
Thank,for your best code it work well.
pichai
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks