<According to Help for .GoTo
......Reference Optional Variant. The destination. Can be a Range object, a
string that contains a cell reference in R1C1-style notation,....
</According to Help for .GoTo

So, you have to convert your address to the correct format and remove the
[Bookx.xls] that gets added
Application.Goto Reference:=Mid(Application.ConvertFormula(ActiveCe ll.Value,
xlA1, xlR1C1), Len(ActiveCell.Parent.Name) + 6)

I doubt this is the best way of achieving this, but it works.

NickHK

wrote in message
ps.com...
Hello fellow programmers! I am in need of some help trying to get my
macros to goto a specific location from a sheet...I'd figure the code
would look like this...

Application.Goto Reference:="ActiveCell.Value"

The problem is I am told my refrence isn't correct..however I have
tried to format it the way it works when I use the "Goto" function of
Excel (CRTL + G) the format I am using in the active cell is...

SheetDB1!B65500

When I copy this code and use the goto function it works fine but the
macro is failing to realize what it is I am trying to do...Any ideas?