Hello,
I am having some issues with a macro I wrote. I am getting the error 2042 and I know what that errors means but my code is correct and I passing the dates correctly but maybe some fresh eyes will help
![]()
Dim startDate As String Dim vColumn As Variant Dim rng As Range Set rng = Worksheets("Output").Range("d10:aaa10") startDate = InputBox("Enter the Start Date: (mm/dd/yyyy)") startDate = Format(startDate, "mm/dd/yyyy") vColumn = Application.Match(startDate, rng, 0)
Bookmarks