Modify DateTime for Application.Match - error 2042

Impossible to tell without more information.

try breaking down your code and see where your fault lies.

[CODE]
D1 =w ' D1 should be a number ie 5 not "5". If it is "5" then modify to "5" *1

D2 = OpenTime_modified = Int(Cells(x, 4).Value 'D2 should be a Time "00:05:00"

D3 = OpenTime_modified = Int(Cells(x, 4).Value + TimeSerial(0 + w, 0, 0)) 'D3 should be a should be a Time "00:05:00" a date and time "22/05/2015 00:05:00"


When you are trying to perform a match, you say your match works before you add Timeserial.
So I assume it cannot be a mismatch due to your Data being stored in Excel as Numbers and your OpenTime being stored in VBA as String. As suggested by Jindon below:

[/CODE

I don't follow what you are asking, what "mint" dates and Times are, or what your data configuration is. I do notice two things.


OpenTime_modified = Int(Cells(x, 4).Value + TimeSerial(0 + w, 0, 0))

The Int function will strip the Time value. An integer is just a date with no time. So OpenTime_modified will be just a date with no time.



RowNumber = Application.Match(OpenTime_modified, Range("DateTime"), 0)

In your code, the Match function is missing the Match-type argument.

Syntax

MATCH(lookup_value,lookup_array,match_type)

• Lookup_value is the value you use to find the value you want in a table.
• Lookup_value is the value you want to match in lookup_array. For example, when you look up someone's number in a telephone book, you are using the person's name as the lookup value, but the telephone number is the value you want.

Lookup_value can be a value (number, text, or logical value) or a cell reference to a number, text, or logical value.

Lookup_array is a contiguous range of cells containing possible lookup values. Lookup_array must be an array or an array reference.

• Match_type is the number -1, 0, or 1. Match_type specifies how Microsoft Excel matches lookup_value with values in lookup_array.
• If match_type is 1, MATCH finds the largest value that is less than or equal to lookup_value. Lookup_array must be placed in ascending order: ...-2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE.
• If match_type is 0, MATCH finds the first value that is exactly equal to lookup_value. Lookup_array can be in any order.
• If match_type is -1, MATCH finds the smallest value that is greater than or equal to lookup_value. Lookup_array must be placed in descending order: TRUE, FALSE, Z-A, ...2, 1, 0, -1, -2, ..., and so on.
• If match_type is omitted, it is assumed to be 1.