|I have an excel formula like this =(b1Scores!BD3)|
but I want the digit 3 to be taken from a cell "B3" (that my VBA will write)
I think I need to use the INDIRECT but I can't get the syntax correct. This is what I have
It shows this error #NAME?