Why am I not getting the next blank cell when I use the offset property? It was working fine for me and now all of a sudden it decided to quit.
Selection.End(xlDown).Select
ActiveCell.Offset(0, 1).Activate
when debugging, the first line shows as 8 (the last filled cell). The second line shows as B65536, which is not the next empty cell in the next column, which is what I want to select.
Am I misunderstanding offset?
Bookmarks