I'm messing up some sort of syntax rule.
I'm trying to get cells a1:a10 in sheet2 in file "rowdata.xlsx" as a rowsource
I tried inputting [rowdata.xlsx]sheet2!a1:a1
0 but it didn't work.
VBA did not accept that!
Please help with syntax. See graphic for what I have so far!