Anyone can help me correct on below code:
i need the answer in row 4
Untitled.jpg
Dim lastcol As Long
lastcol = Cells(Columns.Count, "xfd").End(xlToLeft).Column
Range("a4:XFD" & lastcol).FormulaR1C1 = "=R[-3]C+R[-2]C"
Anyone can help me correct on below code:
i need the answer in row 4
Untitled.jpg
Dim lastcol As Long
lastcol = Cells(Columns.Count, "xfd").End(xlToLeft).Column
Range("a4:XFD" & lastcol).FormulaR1C1 = "=R[-3]C+R[-2]C"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks