"Goto Reference:=" Fails

In a small program I wrote years ago there is a line -
Application.Goto Reference:=Range((BalQtr), where BalQtr is a Sheet name.
The program has run for years without problems but now chokes on this line with Error 1004 "Method 'Range' of object'_Global failed.
I may have messed up this line when doing something else but does anyone know what's wrong ?
Stuart

try:

Please Login or Register  to view this content.

Thank you for reply but It doesn't work. Get again Error1004 Method 'Goto' of object '_Application' failed
Stuart

Thank you for your answer but it does not work either. This time we get Runtime error '9' "Subscript out of range". I don't understand this. Perhaps there is one thing I should mention. BalQtr is a string variable. Earlier in the code it is set to "Q4Bal", which is the name of a sheet. I set a Watch for Q4Bal when running the trials and it shows it as "Q4Bal".
Stuart

Thank you. That did it !*