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","")
I suspect the LastRow - 1 gives zero or negative number.
Mr Chan
I think it is -- the lastrow was 0!
Thank you for your reply...
