Hi,
I have a vba that insert a formula in cell AT2 across all sheets. So far, so good.
Now I have tried to autofill this formula across all sheets to the last column. But end up with a 'compile error: Method or data member not found'.
vba is the below:
Any idea. Thks
I have a vba that insert a formula in cell AT2 across all sheets. So far, so good.
Now I have tried to autofill this formula across all sheets to the last column. But end up with a 'compile error: Method or data member not found'.
vba is the below:
VBA Code:
Sub Sheet_Date2()
With ThisWorkbook.Worksheets
Dim lastRow As Long
lastRow = .Item(1).Range("AR" & Rows.Count).End(xlUp).Row
.Range("AT2").AutoFill Destination:=.Range("AT2:AT" & lastRow)
.FillAcrossSheets.Item(1).Range ("AT2"), xlFillWithAll
End With
End Sub
Any idea. Thks
Last edited by a moderator: