Ardus Petus...

Still getting "Run-time error '1004' Reference is not valid." Even if
its a simple

Application.Goto ActiveCell.Value

it still craps out...any thoughts?


Ardus Petus wrote:
Suppress the quotes!
Application.Goto Reference:=ActiveCell.Value

HTH
--
AP

a écrit dans le message de news:
...
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?