Thread
:
Application.Goto Reference:="ActiveCell.Value"??? Whats wrong??
View Single Post
#
2
Posted to microsoft.public.excel.programming
Ardus Petus
external usenet poster
Posts: 718
Application.Goto Reference:="ActiveCell.Value"??? Whats wrong??
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?
Reply With Quote
Ardus Petus
View Public Profile
Find all posts by Ardus Petus