VBA - Selecting a cell based on relative position vs cell #

Hello,
I am creating a macro in VBA, but I'm not a great programmer. I usually use the 'record' function and tweak the code to make edits. I would appreciate any and all advice/help!

I am trying to select the last two cells in a row and copy them to another sheet. When I record this macro it shows up as:

<< Range("A2").Select
Selection.End(xlToRight).Select
Range("P2:Q2").Select
Selection.Copy>>

The problem with this is that it isn't sustainable. The most recent data (the cells I want to copy) might not always be in cells p2 and q2. Ultimately I just want to copy the LAST TWO CELLS (furthest to the right), regardless of their position. Is there a code to do this?
Thanks!

jago_ML,

myRow and myLastColumn are actually variables. They are not functions.

Please Login or Register  to view this content.

This is simply assigning the value of 1 to the variable myRow

Please Login or Register  to view this content.

This is finding the last column with information in it on Row 1 (myRow) and assigning the value to the variable myLastColumn.

The is very useful when doing a loop such as

Please Login or Register  to view this content.

Each time the code loops myRow is incremented by 1 in this particular example.

Hopes this help you understand things a little better!

Try this and see if it gives you what you are wanting.

Please Login or Register  to view this content.

I was not sure where you want the data placed on Sheet1 so I put it in the first two cells on row 1. You can easily change that by editing

Please Login or Register  to view this content.

Hope this helps you move forward with what you are doing.