Sorry if I did this wrong, first topic.
The path I am refering to is the range path. If I click the + and I indicate the spreadsheet it gives back
Excel.Sheet[“Sheet1”] This does not work. It gives an error, end of expression expected.
not
Excel.Sheet(“Sheet1”) This works.