excel vba write value to the referenced cell formula location
Posted on 2016-11-16
In sheet1, cell A1, I have a formula =Sheet2!C3
In VBA Code I need to be read cell Sheet1!A!, return the referenced location of Sheet2!C3, and write a value to the Sheet2!C3 cell.
it will only ever be a single cell location rather then a range that is referenced
Could someone share some code to achieve this please