• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 416
  • Last Modified:

Finding application.goto reference in excel 2007

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
Selection.Copy
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?
0
thorpey83
Asked:
thorpey83
  • 2
  • 2
2 Solutions
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

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

cheers, teylyn
0
 
NorieCommented:
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.
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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
4-10-2011-12-38-49-p.m..png
0
 
broro183Commented:
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, (www.decisionmodels.com) and Matthew Henson (mhenson@mac.com) and can be downloaded from:
http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp?AllComments=True

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..


hth
Rob
0
 
broro183Commented:
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.

Rob
0

Featured Post

Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now