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.

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.

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.

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.

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