Application.Goto Reference:="ActiveCell.Value"??? Whats wrong??
- From: Shaka215@xxxxxxxxx
- Date: 12 Jul 2006 01:36:29 -0700
Hello fellow programmers! I am in need of some help trying to get my
macros to goto a specific location from a ***...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?
.
- Follow-Ups:
- Re: Application.Goto Reference:="ActiveCell.Value"??? Whats wrong??
- From: Norman Jones
- Re: Application.Goto Reference:="ActiveCell.Value"??? Whats wrong??
- From: NickHK
- Re: Application.Goto Reference:="ActiveCell.Value"??? Whats wrong??
- From: Shaka215
- Re: Application.Goto Reference:="ActiveCell.Value"??? Whats wrong??
- From: Ardus Petus
- Re: Application.Goto Reference:="ActiveCell.Value"??? Whats wrong??
- Prev by Date: Re: How much memory does VBA code occupy?
- Next by Date: Re: Is 300,000 Named Ranges going to cause problems?
- Previous by thread: Re: How much memory does VBA code occupy?
- Next by thread: Re: Application.Goto Reference:="ActiveCell.Value"??? Whats wrong??
- Index(es):