I’m sick of writing this
I want a new argument to the End property. I want to type
I would prefer if this new argument mirrored the code above. That is, I would prefer if it returned a range from the current cell until the last cell in that column. That’s as opposed to returning a range from the current cell to the cell just above the first blank cell, as you should get if you used Ctrl+Shift+Down on the keyboard. But I’d be happy either way.
The other thing this new argument would have to do is know when B2 is the only cell or there is nothing in B2:B?. Oh, screw it. Here’s a table of what I want.
|B2:B10 contains contiguous values||B2:B10||B2:B10||B2:B10|
|B2:B10 contains a blank at B5||B2:B10||B2:B4||B2:B10|
|B2:B10 has a blank at B2||B2:B10||B2:B3||B2:B10|
|B2 is the only cell in B||B2:B2||B2:B1048576||B2:B2|
|Column B is empty||B1:B2||B2:B1048576||B2:B2|
I guess that wasn’t so complicated. It should act just like going up from the last cell except when the column is empty. In that case, it should just return the one cell.
Who’s with me?