Copy contents in column A and paste it 1 row below

Hello team,

I need to copy all contents in column A, and paste it 1 row below in the same column.

Actual situation -> see sheet 1. How it should look -> see sheet 2.

I will use this vba code in different workbooks. Column is always A, but number of rows which has contents change (Up to 4500 rows).

I know that I can do it by copy and paste it 1 row below, but is this possible with a vba code too?

Thanks for your help and replies.

Please Login or Register  to view this content.

Originally Posted by rcm

Please Login or Register  to view this content.

Thanks for your reply rcm. This works exactly like I want it.