Finding application.goto reference in excel 2007

Posted on 2011-10-03
Last Modified: 2012-05-12
Hi All,

I have inherited an old spreadsheet which was maintained by an old employee. In this spreadsheet there is a macro which runs a 'price increase'. This price increase selects all cells identified in the following reference;

Application.Goto Reference:="CompanyX_CopyFrom"
Application CutCopyMode = False
Application.Goto Reference:="CompanyX_CopyTo"
Selections.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks -
        := False, Transpose:=False

All is working ok, however I need to adjust the cells selections in the application.goto reference and I cannot find reference to these anywhere.

Can anyone help me locate these to adjust?
Question by:thorpey83
    LVL 50

    Accepted Solution


    these seem to be named ranges. Open the Name Manager on the Formulas ribbon and you should see these listed.

    cheers, teylyn
    LVL 33

    Assisted Solution

    Have you checked in the name manager?

    Or even just entering CompanyX_CopyFrom into the Name Box and hitting enter.

    Might also be worth looking in the rest of the code - the references might be created
    at an earlier point.
    LVL 50

    Expert Comment

    Select the range name in the Name Manager and then you can change the reference in the Refers to box at the bottom. See screenshot.

    cheers, teylyn
    LVL 10

    Expert Comment

    hi Thorpey83,

    I've just posted a very similar answer in another thread, an I hope this helps you too...

    I suggest downloading and trying "JKP Name Manager" to find where the two names are hiding.

    The JKP Name Manager is a very useful and free excel addin, collaboratively created by Jan Karel Pieterse (JKP), Charles Williams, ( and Matthew Henson ( and can be downloaded from:

    I use it in my work almost every day and it is regularly updated as bugs or optimisations are identified so I occasionally compare the latest Build number on the website (currently it is #630) with the version on my machine.

    For your purposes,  after installing & loading the addin (see the Formulas ribbon in excel 2007 or use [ctrl + shift + n] to bring it up) to see these names, if they still exist. To do this you can just adjust the settings of the JKP Name Manager to show "all" Names and "all" Name Types. (instructions are included with the download) and the popup is fairly self explanatory..

    LVL 10

    Expert Comment

    Ooopps, I am too slow again.

    Oh well, I still recommend JKP's Name Manager over the "native" Name Manager in excel as JKP's version provides more functionality.


    Featured Post

    How does your email signature look on mobiles?

    Do your employees use mobile devices to reply to emails? With mobile becoming increasingly important to the business world, it is in your best interest to make sure that your email signature looks great across all types of devices.

    Join & Write a Comment

    Suggested Solutions

    I was supporting a handful of Windows 2008 (non-R2) 2 node clusters with shared quorum disks. Some had SQL 2008 installed and some were just a vendor application that we supported. For the purposes of this article it doesn’t really matter which so w…
    Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now