Forum Discussion

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

Matt Mickle
Jul 17, 2018
You can drop the WorksheetFunction portion for easier readability:

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

Silver Contributor

Jul 14, 2018

Hi Lorenzo,

The Cells function requires two arguments: RowIndex & ColumnIndex

Both must be a number, not a text!

You put the text "C" in the ColumnIndex, so try to replace it with 3 instead.

Regards

Bronze Contributor

Jul 14, 2018

Mr. Amairah
Thank you for your time...