Hi, I am looking for a way to update all the formulas in the rectangle shapes in all worksheets. They are all linked to the same column (current month) but different rows, so when it's next month and time to update, I am looking to create a prompt which user would put the old Column (i.e. $BH$) then the new Column (i.e. $BI$) that they want to replace with. But when I recorded the macro below, the formula is in R1C1 style. I am not sure how to convert that into the regular formula. Also if someone could help me with looping throughout the entire workbook. Thank you for your time.
Code:
Sub Macro10()
ActiveChart.Shapes("Rectangle 1").Select
ExecuteExcel4Macro "FORMULA(""=Data!R18C60"")"
End Sub
