VBA does not need to "GoTo" or "select" or "activate" a cell to do something
to it or read something from it: that will just slow down your VBA to a
crawl.

all you need to do is to reference the cell:
worksheet("SheetDB1").Range("B65500")=123.456
or
worksheet("SheetDB1").Range("A1").offset(65499,1)= 123.456
or
worksheet("SheetDB1").Cells(65500,2)=123.456
or ....

regards
Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com

wrote in message
ups.com...
Nick I like your way of thinking but that isn't working either...the
[Bookx.xls] isn't in the activecell.value code and its not ever going
to be...I simply want VBA to understand that it is to goto a specific
area of the individual workbook and do something (which Ill program it
to do) however the refrence error happens with your code...even when I
put in the workbook name inside of the activecell.value... thanks for
atleast attempting to slove the issue.


NickHK wrote:
<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?