I have a spreadsheet in which the content’s of a cell refers to another cell e.g.
Cell A1 content’s are “=b2” . I need to write a program in which I can edit the string “=b2”. The question I have is what property (or keyword) do you place after Cells(1,1).??? To get the string “=b2”?
Cells(1,1).FormulaR1C1 almost works but it returns the string “=R2C2”. Strangely Cells(1,1).FormulaA1 generates an error message altogether (This method or property is not supported). Can anyone help me out?