I have foreign (non-English) characters in a cell which I was reading using Sheets("data").Cells(1,1).Formula
However this returned nothing but questions marks instead of the text:e.g. ζχψωβνιθςεβφ[ςε turns into "????ί????eίf[?e"
After research I discovered I needed to set the regional...