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