| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select an empty cell
I need a piece of code which will look at column C and find the first empty
cell in the column (must be below row 6) and then select the cell in column B of that row. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select an empty cell
Something like that
cells(cells(6,3).end(xldown).row + 1, 2).select On Jan 21, 1:39*pm, "Patrick C. Simonds" wrote: I need a piece of code which will look at column C and find the first empty cell in the column (must be below row 6) and then select the cell in column B of that row. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select an empty cell
That does not move down to the first empty cell in column C.
"carlo" wrote in message ... Something like that cells(cells(6,3).end(xldown).row + 1, 2).select On Jan 21, 1:39 pm, "Patrick C. Simonds" wrote: I need a piece of code which will look at column C and find the first empty cell in the column (must be below row 6) and then select the cell in column B of that row. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select an empty cell
hi
try this... Range("C6").end(xldown).offset(0,-1).select regards FSt1 "Patrick C. Simonds" wrote: That does not move down to the first empty cell in column C. "carlo" wrote in message ... Something like that cells(cells(6,3).end(xldown).row + 1, 2).select On Jan 21, 1:39 pm, "Patrick C. Simonds" wrote: I need a piece of code which will look at column C and find the first empty cell in the column (must be below row 6) and then select the cell in column B of that row. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select an empty cell
On Jan 21, 2:05*pm, "Patrick C. Simonds"
wrote: That does not move down to the first empty cell in column C. "carlo" wrote in message ... Something like that cells(cells(6,3).end(xldown).row + 1, 2).select On Jan 21, 1:39 pm, "Patrick C. Simonds" wrote: I need a piece of code which will look at column C and find the first empty cell in the column (must be below row 6) and then select the cell in column B of that row.- Hide quoted text - - Show quoted text - Yeah, it does not, because your request was: I need a piece of code which will look at column C and find the first empty cell in the column (must be below row 6) and then select the cell in column B of that row. And that's what my code does! If you want to move down to the first empty cell in column c and select this cell you could do this: cells(cells(6,3).end(xldown).row + 1, 3).select which basically is the same but the last number has been changed from 2 (column B) to 3 (column C) hth Carlo |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| select next empty cell | Excel Discussion (Misc queries) | |||
| How to select automaticly the last cell not empty of a area? | Excel Worksheet Functions | |||
| Function to select second-to-last non-empty cell | Excel Worksheet Functions | |||
| select first empty cell in a range | Excel Programming | |||
| Select Until Empty Cell From VBA Code | Excel Programming | |||
Hybrid Mode
