Application.Worksheetfunction.match ERROR

Hi!

I'm using a worksheet function in a piece of VBA code to get the column number of an specific date. It seems that the Match Function is unable to find the date even though the Date does exist in a column in the First row of the sheet "Lecturas". I've tried using the Match Function in Excel itself and the capturing the cell value t use it in mu code. This works but I'd rather be able to come up with this value using code only. The code I'm using is as follows:

Please Login or Register  to view this content.

Thanks!