Forum Discussion

Lorenzo Kim's avatar
Lorenzo Kim
Bronze Contributor
Jul 14, 2018
Solved

runtime error 1004 : Method range of object - 'Global' failed

How do I correct this? (kindly see images) many many thanks    
excel
Macros and VBA
Man Fai Chan's avatar
Man Fai Chan
Iron Contributor
Jul 15, 2018

Dear Kim,

 

The statement is as follows:

 

New_text = Application.WorksheetFunction.Substitute(Cell_reference,"TOTAL","")

 

Cheers,

Chan M F

Matt Mickle's avatar
Matt Mickle
Bronze Contributor
Jul 17, 2018

You can drop the WorksheetFunction portion for easier readability:

New_text = Application.Substitute(Cell_reference,"TOTAL","")

Resources