New to this list but have used VBA with Excel for over 13 years both professionally and since retirement.

I have a neat macro that annually archives 'dead' records from a membership database and then goes on to reset/clear columns ready for the new year. The macro has been progressively modified to exploit excel 'tables' and referenced via the ListObject technique and that worked last year. An enhancement this year is the introduction of a Row Id which is populated using any of the manual autofill techniques.

I now want to automate the autofill using ListObject.Listcolumns notation.
So far I have :
With lobjMembershipList
.ListColumns(64).DataBodyRange(1) = "1"
.ListColumns(64).DataBodyRange(2) = "2"
.ListColumns(64).DataBodyRange.AutoFill Destination:=.ListColumns(64).DataBodyRange, Type:=xlFillSeries
End With

The first two statements work but how do I need to modify the Autofill statement to get it to work?
Software: Excel 2007

Thanks
Nigel