Match function to return column number for matching date errors

[martinez77]

Hello All,

I am trying to use some vba match function code to return the column number of the matching date. The date will be stored in a date variable.

Every time I run this code I normally get a match error even though the date is in the worksheet and the variable matches that date.

See below:

Please Login or Register  to view this content.

Thanks

[mongoose36]

See Below

Please Login or Register  to view this content.

[stnkynts]

You are going to run into multiple issues with the use of Long versus variant and then error checking against the match. In addition, the date formats combined with the inputbox and trying to get them the same to be recognized by .Match can be troublesome at times. I suggest doing something like this which in your case should be just as fast:

Please Login or Register  to view this content.

[jindon]

Try change to

Please Login or Register  to view this content.

[martinez77]

Thank you guys,

Jindon found exactly what I was looking for. Thanks!

M

[martinez77]

Thank you guys,

Jindon found exactly what I was looking for. Thanks!

M