Last cell in range
Let say Im using this code:
Range("A1").End(xlDown).Select
Lets say: Cell A1:A3 contain values. That code would
select cell A3. I want it to select cell A4(which is 1
cell more than the target). How do I get it to do this?
-----Original Message-----
Todd,
It skips blank cells
Actually it doesn't "skip" them.
It looks from the bottom of column "A" upwards until it
finds a non-blank cell.
To modify it, use
Range("A1").End(xlDown).Select
That'll look downward from A1 until it finds the first
non-blank cell.
And also(2nd modification) how do I make it select the
first cell in the range that has no value skipping
blank?
I'm not sure what you mean by that statement??
John
"Todd Huttenstine"
wrote in message
...
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
.
|