Hello
Ive been trying desparately to accomplish the following:

I need to check for a value in a row on a cell by cell basis.
Columns B,C,F,G may or may not have a value in them.
If B is empty, then clicking on a commandbutton places the caption text into
the cell and moves to column C; Clicking on a command button again places
its caption text into that cell and jumps to Col F; again clicking the
command button places the caption text in the cell in Column F and again
with G.
When those cells on that row are filled, I then need to have excel find the
last row + 1 to begin it all over again.

Column A has a formula in it down to row 60 and in the 2nd row (A2:K2) have
column heading in them.
Columns D, E, H, I are all hidden columns with formulas.

How can I accomplish this?
Ive tried :
Range("B65536").End(xlUp).Offset(1, 0), but If column B has a value and C
does not, then the offset brings it down another row.
Im thinking that I should be using xlRight somehow, but I can't seem to get
my head around it.

Could anyone shine a little light for me?
Thank you so much

Terry V