Offset Top Left, Bottom Right backwards?

[Centexcel]

Excel Forum;

It is my understanding (I am studying a VBA book) that I can set up a range with 2 offset methods, the first selects the top left and the second the bottom right of my desired range. Unfortunately, it seems my understanding of this technique is off. To me, my code appears to select the bottom right first and then the top left of the range. What am I doing wrong?

My variable nEMP selects my desired range, however, I thought the offset terms would be switched. (I began with .offset(3,1) and .end(xldown) and .end(xltoright) and that didnt work)
My variable notWorking selects the incorrect range, yet I read it as selecting the headings of the scores. (I would like notWorking to select the nScores range but I want to use the offset method.

Please Login or Register  to view this content.

Thank you for your help.

[AB33]

Please Login or Register  to view this content.

You can only OFFset from a reference point(Range). Which Range is your range?

Please Login or Register  to view this content.

You are selecting B4, that is going 3 down and 1 to the right, start counting from zero(A1)

[shg]

Maybe

Please Login or Register  to view this content.

[JS411]

It is my understanding (I am studying a VBA book) that I can set up a range with 2 offset methods, the first selects the top left and the second the bottom right of my desired range. Unfortunately, it seems my understanding of this technique is off. To me, my code appears to select the bottom right first and then the top left of the range. What am I doing wrong?

The order of the references provided to the Range Property doesn't matter, as you can test with this code...

Please Login or Register  to view this content.

The unexpected results you're finding might be due to your understanding how this statement is evaluated...

Please Login or Register  to view this content.

It looks like you want to the expression in blue font to return Cell F4.
However that expression is equivalent to :

Please Login or Register  to view this content.

In your example workbook, that expression will return Cell XFD1.
You can see why this happens by manually selecting A1 then keying Ctrl+Right Arrow

If you want to get the last non-empty cell in a Row, it's more reliable to use xlToLeft like this..

Please Login or Register  to view this content.

[Centexcel]

Wow, this is exactly the response I was looking for.
Thank you for making this more clear for me!

I hope once I master VBA I can help others too. Thanks again.