Avatar of thorpey83
thorpey83
Flag for Australia

asked on 

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?
Microsoft ExcelWindows Server 2008

Avatar of undefined
Last Comment
Rob Brockett

8/22/2022 - Mon