Hi Team,
Please assist to make R1C1 formula dynamic. Thanks
Below are my code my attempted Code.getting error at formula.
Sub R1C1_Dynamic()
Dim wbk As Workbook
Dim wsh As Worksheet
Dim mwbk As Workbook
Dim msh As Worksheet
Set mwbk = ThisWorkbook
Set msh = mwbk.Worksheets("Sheet1")...