runtime error

[rickblunt]

Greetings,
I noticed that that "offsets" are used by a lot of you when you are ranging userforms and input boxes. It seems like a pretty good technique to use instead of hard coding ranges so I thought that I would start learning this. If I understand this correctly the first column is the row and the second number is the column, pretty straight forward. However, I am getting a runtime error when I try to use this so apparently I am missing something.

For example, if I am trying to send my data to the "next blank" row. I thought that I would use this string, but I get a runtime error...

Range("A1").End(xlDown).Offset(1, 0).Select

This string does not give me a runtime error, but the data ends up in B1048576 - I get the "B" column, but zero gives me the last row in the worksheet?

Range("A1").End(xlDown).Offset(0, 1).Select

Would anyone mind explaining what is wrong with the initial string? Thank you for any insight.

 

[BobUmlas]

IF the xlDown from A1 takes you to the lasts cell (A1048576), then the error is in trying to go one more row down (Offset(1,0)) which doesn't exist.

Range("A1").end(xldown) would take you to A1048576, then Offset(0,1) would be B1048576.

 

[rickblunt]

oh, of course - that makes total sense (I should have picked up on that myself because I tried 0,0, and got that exact result that you are describing). But what would be the right number to use for the next row?

I guess I am confused because if (0,1) takes me to column "B", why doesn't (1,0) take me to Row 2? I didn't type in (1048576,1) to the string....

 

[V_Malkoti]

With your current code

Range("A1").End(xlDown).Offset(1, 0).Select

you are trying to get the next row of last row in the sheet, which causes an error.

If you want to get the cell in next row, then write

Range("A1").Offset(1, 0).Select

 

[rickblunt]

Oh, okay - so the xlDown takes you to the end of the WS, I thought it just meant "down". Thank you both for the knowledge, it is very appreciated.