Find next empty cell in row - query

[vinny2984]

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

Range("A" & Rows.Count).End(xlUp).Offset(1).Address

 

[Domski]

Try:

Cells(1, Columns.Count).End(xlToLeft).Offset(0, 1).Address

Dom

 

[Weaver]

Cells(rowNum, Columns.Count).End(xlToLeft).offset(0,1)

would give you next free cell on row rowNum

 

[vinny2984]

Re: Find next empty cell in row - solved

Yep, that works great, many thanks