The problem is cannot find "sn"~~
Please Login or Register to view this content.
tdate is a date, e.g. "2009/6/23"
the format of field is shown as followings,
r2.Columns(1) : EM001
r2.Columns(4) : 2006/9/1
I checked many times~~The problem is the same..
Please help me to solve it~thank you
Last edited by thy00123; 07-03-2009 at 05:14 AM.
Try using the Long equiv. of your Date in the Match, ie:
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
This method cannot solve this problem~~but thanks for your replyOriginally Posted by DonkeyOte
Try using the Long equiv. of your Date in the Match, ie:
Please Login or Register to view this content.
Post a sample file in which your issue can be replicated.
I have uploaded the sample program~~
OK, well your first problem is that in the vba file your date values are datetime stamps whereas in your lookup file they are seemingly only date values (no time) in which case you need to revise tdate:
then in the Match convert tdate to Long as advised previouslyPlease Login or Register to view this content.
What do you want to do should the Index/Mail fail as will be the case with the 2nd date in the VBA File ...Please Login or Register to view this content.
I have tried that method, it can solve my problem~~thanks~~OK, well your first problem is that in the vba file your date values are datetime stamps whereas in your lookup file they are seemingly only date values (no time) in which case you need to revise tdate:
then in the Match convert tdate to Long as advised previouslyPlease Login or Register to view this content.
What do you want to do should the Index/Mail fail as will be the case with the 2nd date in the VBA File ...Please Login or Register to view this content.
Moreover, using "datevalue" also can solve it~~
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks