Below is a code I saw in a post that selects the last cell
in columnA that has a value. It skips blank cells. How
do I make it select the first cell in the range that has
no value.

And also(2nd modification) how do I make it select the
first cell in the range that has no value skipping blank?


Range("A65536").End(xlUp).Select