Last cell in range
 

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

Last cell in range
 

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

Last cell in range
 

Todd,

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

John

"John Wilson" wrote in 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

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


.

Last cell in range
 

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 Huttenstine" wrote in message
...
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


.

Last cell in range
 

Todd,

Many ways...
One of them...

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

John

"Todd Huttenstine" wrote in message
...
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


.

Last cell in range
 

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


-----Original Message-----
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


.

.