Forum Discussion
Solved
runtime error 1004 : Method range of object - 'Global' failed
How do I correct this? (kindly see images) many many thanks
You can drop the WorksheetFunction portion for easier readability:
New_text = Application.Substitute(Cell_reference,"TOTAL","")
for me the msg error appeas at the time I am calling F10 key
' RUN_FORREST_RUN Macro
'
'
ChDir "Y:\Luciano"
ActiveWorkbook.SaveAs Filename:= _
"Y:\Luciano\Segment Report Conso Excel Link.xlsb", FileFormat:=xlExcel12, _
CreateBackup:=False
Sheets("CoA").Select
Range("CoA[[#Headers],[ACCOUNT NUMBER]]").Select
Application.Run Range("cc.F10")
Cells.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
' RUN_FORREST_RUN Macro
'
'
ChDir "Y:\Luciano"
ActiveWorkbook.SaveAs Filename:= _
"Y:\Luciano\Segment Report Conso Excel Link.xlsb", FileFormat:=xlExcel12, _
CreateBackup:=False
Sheets("CoA").Select
Range("CoA[[#Headers],[ACCOUNT NUMBER]]").Select
Application.Run Range("cc.F10")
Cells.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
