Auto fill column in a table

I can't test this for obvious reasons

However try this

Please Login or Register  to view this content.

I have tried to speed your code up a little.
I hope I have not been over zealous.

Hope this helps.

If you need any further information, please feel free to ask further

However

If this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.

I received a run-time error '1004': Autofill method of range class failed.

I do like some of the streamlining that you did. I had thought about using Select Case instead of Ifs, but wasn't sure how it would affect processing speeds. I appreciate the removal of the range selections. I hadn't thought about doing that.

We need a column that has previously been filled by your code (This will be of variable length) to base LastRow on

In the meantime try changing this line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Let me know how it runs after that
I have some suspicions on other lines.

Cheers

Worked perfectly.