Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Last cell in Range when range is date format | Excel Discussion (Misc queries) | |||
RANGE EXCEL copy cell that meets criteria in a range | Excel Worksheet Functions | |||
copy range and paste into every 3rd cell of new range | New Users to Excel | |||
Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) |