vba/macro select last two cells and copy down

[GaryDML]

Hi all
I'm a newbie to vba and i have finally managed (after many hours) to select the last two cells in column AY along with the two cells adjacent in AZ by using the following code:

Please Login or Register  to view this content.

However, I now want to copy that selection e.g. AY2:AZ3 down to the last row.
I tried many things including adding the following line but I can't get it to work...

Please Login or Register  to view this content.

Any help much appreciated!
Cheers

[HaHoBe]

Hi, GaryDML,

maybe like this:

Please Login or Register  to view this content.

Ciao,
Holger

[GaryDML]

Hi Holger
Awesome! Thanks so much! Really appreciate it.
Cheers
Gary