Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 74
Default match function - date and time

Good evening Group,

Have been looking in the archive but not found a complete answer.

Is it possible to use the MATCH function in VBA when looking
for a date/time in format "YYYY-MM-DD hh:mm"? The lookup array
is in the same format.

Brgds

CG Rosen




  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default match function - date and time

Check your other post.

"CG Rosén" wrote:

Good evening Group,

Have been looking in the archive but not found a complete answer.

Is it possible to use the MATCH function in VBA when looking
for a date/time in format "YYYY-MM-DD hh:mm"? The lookup array
is in the same format.

Brgds

CG Rosen


--

Dave Peterson
Reply
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
match function - date and time CG Rosén Excel Discussion (Misc queries) 1 January 19th 08 07:07 PM
Match Date/Time to Date list Sandy Excel Worksheet Functions 4 October 16th 07 07:09 PM
Compare/Find Exact Date match with varying time sweens319 Excel Worksheet Functions 10 October 9th 07 02:47 PM
Worksheet function match - run time error Sajit Excel Worksheet Functions 3 July 8th 07 10:30 PM
MATCH FUNCTION AND SERIAL DATE CONFLICTS Jones the Scouse Excel Worksheet Functions 4 November 1st 06 01:46 PM


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

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

About Us

"It's about Microsoft Excel"