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?
thorpey83Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
NorieVBA ExpertCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.