Enter Row Number as a value in cells

Hi I'm using tables in excel and importing data from different documents. I have got the browse, open, and import (copy paste) nailed down.

when I import the data into the table it populates all but the first column as this is a unique sequential ID. I has chosen to use the row number.

So just before import in the vba I sort the table via this ID column and add the new data to the end.

I then want to add the unique sequential ID number to the new data.

so far I have.... nothing that works

Please Login or Register  to view this content.

any ideas? When I have this working I also want to include the file name in the last column as when opening the file the first check is has it already been imported

thanks

additional information - I have the copy paste as values only as when sorting tables with a formula reference row it obviously changes to what ever row it sits in messing up the data

How does the code not work?

If you don't want the formula do a copy and paste special values.

Please Login or Register  to view this content.