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_CopyF
Application CutCopyMode = False
Selection.Copy
Application.Goto Reference:="CompanyX_CopyT
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?
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_CopyF
Application CutCopyMode = False
Selection.Copy
Application.Goto Reference:="CompanyX_CopyT
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
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
Oh well, I still recommend JKP's Name Manager over the "native" Name Manager in excel as JKP's version provides more functionality.
Rob
cheers, teylyn
4-10-2011-12-38-49-p.m..png