Last cell in range

  • Thread starter Thread starter Todd Huttenstine
  • Start date Start date
T

Todd Huttenstine

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
 
Todd,
It skips blank cells
Click to expand...
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?
Click to expand...
I'm not sure what you mean by that statement??

John
 
Todd,

Modify this statement:
Range("A1").End(xlDown).Select
That'll look downward from A1 until it finds the first non-blank cell.
Click to expand...
to read.......................
Select the cell in column "A" just above the first blank cell it encounters
below A1.

John
 
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?
 
Todd, try this, Range("A1").End(xlDown).Offset(1, 0).Select


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
Todd,

Many ways...
One of them...

Range("A1").End(xlDown).Offset(1,0).Select

John
 
Ahh the offset method once again. Man I keep forgetting
about that. That is the most helpful function.
 
Back
Top