Macro to find next empty cell in specific range

I am trying to write code that will post a value into the next empty cell in range B14:b33, searching downwards. I have searched the forums and seen lots of things 'almost' like my problem, but generally they are to find the first empty row, whereas I want to find the first empty cell in the particular range, even if there is data in the rest of the row or column.

I have tried lots of things but can not get it to work. The closest I have come is
Range("B14").End(xlDown).Offset(0, 1) = "1"
But this puts the value into the cell offset from where the button is, and not from b14 downwards.

I know it is probably really simple and I would be very grateful if anyone can point out where I am going wrong :-(

Thanks
Nina

Try:

Please Login or Register  to view this content.

with Offset(0, 1) you are selecting the cell to the right (in column C), but with (1, 0) you are selecting the next one down.

Thanks for this, schoolboy error