Any ideas where I'm going wrong here? I'm trying to define my variable as the column number where the header is "Results". Then I want it to tell me the value so that I know it works before I proceed. It displays the following error message "Unable to Get the Match Property of the worksheet function class".
![]()
Sub match() Dim results as integer Results = worksheetfunction.match("Results", "A1:M1", 0) results.print end sub
Bookmarks