I have used the following code many times to find the next empty cell in a column but on this occasion i need to find the next empty cell in a row. i thought I could change the below code from column to row, but so far I can't make the syntax work. Can anyone help me out?
thanks
thanks
Code:
Range("A" & Rows.Count).End(xlUp).Offset(1).Address