Select an empty cell

[Patrick C. Simonds]

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.

 

[carlo]

Something like that

cells(cells(6,3).end(xldown).row + 1, 2).select

 

[Patrick C. Simonds]

That does not move down to the first empty cell in column C.

Something like that

cells(cells(6,3).end(xldown).row + 1, 2).select

 

[FSt1]

hi
try this...
Range("C6").end(xldown).offset(0,-1).select

regards
FSt1

 

[carlo]

That does not move down to the first empty cell in column C.


Something like that

cells(cells(6,3).end(xldown).row + 1, 2).select



- 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