Last cell in range

  • Thread starter Todd Huttenstine
  • 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
 
J

John Wilson

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
 
J

John Wilson

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
 
P

Paul B

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 **
 
J

John Wilson

Todd,

Many ways...
One of them...

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

John
 
T

Todd Huttenstine

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