I'm trying to collate data from several list validation cells into another workbook. I have created a seperate function to loop through any given validation cell. There are 4 cells i am trying to loop over:
1st contains a list of aircraft
2nd contains a list of countries
3rd contains a list of...
I am trying to evaluate a formula with this code
Dim myRange As Range
Set myRange = Worksheets("Sheet1").Range("A1:B10")
'answer = Application.WorksheetFunction.Max(myRange)
answer = [SUMPRODUCT((LEN(myRange)>0)*1)]
But I getting an error...