Why am I getting the following Error Message on the Below codes.
Run-time error '424':
"Object required"
Requesting our dear members to Kindly rectify this issue. Thank You.
Run-time error '424':
"Object required"
Code:
Public Sub NewIT()
Dim Employees As ListObject
Set Employees = ThisWorkbook.Sheets("Employees").ListObjects("Employees")
Call ThisWorkbook.Worksheets.Add(After:=Employees.Parent, Count:=Employees.ListRows.Count)
Dim Individuals As Worksheets
Set Individuals = Array(ThisWorkbook.Worksheets.Add(After:=Employees.Parent, Count:=Employees.ListRows.Count))
Call Individuals.FillAcrossSheets(Employees.HeaderRowRange, xlFillWithAll)
End Sub
Requesting our dear members to Kindly rectify this issue. Thank You.