the INDIRECT function does not work if the workbook file name has a hyphon (-) in it
the INDIRECT function does not work if the workbook file name has a hyphen (-) in it
Yeah dude, I understand just fine. It's not complicated.
indirect("Sheet1!a1",1) works, indirect("She-et1!a1",1) does not work ( when the worksheet is called She-et1) .The work sheet nor workbook names cannot have a hyphen. Didn't work on version 2007 nor on version 2016 MSO so can't see how Roy can say it does on Versions 2009 and version 2016. He obviously doesn't understand the problem I've got. Hence my detail given above.