I can never seem to find what I'm looking for using the search tool on this site. I typed in
"offsetting up or down", and found several matches for offsetting, but nothing for up or down.
question: I know how to select the last cell in a column containing text, and offset it left or right by any number of
How do I do the same, and move the selection up or down?
Before you tell me there's a better way than using
.select, I realize that, but I'm not ready to delve that deep into VBA yet. The cumbersome and slow part of my macro is
performing all of the vlookups. I can't imagine selecting a few cells having that much of a performance factor.
Thanks for all the help.