Hi
I'm unable to match a cell value with a sheet name in circumstances when the sheet name is a number.
eg.
Say the name of the active sheet is "49"
Also, the value in cell A1 is also "49"
This expression won't work. It's something to do with having a number as a sheet name. Can I modify this expression?
Cheers
Lee