Norma's code worked great...thank you for trying to help.

NickHK wrote:
You could try some debugging yourself, to check the value returned at each
stage.

Correction:
Mid(Application.ConvertFormula(ActiveCell.Value, xlA1, xlR1C1),
Len(ActiveCell.Parent.Parent.Name) + 3)

NickHK

wrote in message
ups.com...
Nick,

Check your code because it isn't working...I keep getting told that the
refrence is invalid. It seems that even with the understanding that the
workbook name is inserted once its converted it still isn't making a
diffrence. I only want my macro to understand that it is to goto...

Sheet: DB1
Cell: B65500

There for its "DB1!B65500" in the activecell.value ?????? Is there a
pieace of code that converts the DB1!B565500 into the crappy refrenced
format of "DB1!R[2]C[-13]" without having to actually change the
properties of the cell, I mean even it does I can work around this but
somehow my formatting has to be changed by the macro and since I never
used the 'crappy formatting' then I am at a lost...


NickHK wrote:
You do not need to "put in the workbook name inside of the
activecell.value".
It is generated by .ConvertFormula and consequently must be removed to
give
a valid value for .Destination.

NickHK

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?