Finding next empty row with specific column location

[Bryancarlo]

Hi,

I have set this to locate the next empty row: irow = ws.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
but sometimes my columns from A-F dont have any data. just would like to have a condition where the basis for finding the next empty row is column G. It should find the next empty row from the last data entered in column G.

Thank you

 

[Fluff]

Hi & welcome to MrExcel.
Just change the 1 in Cells to 7

 

[Bryancarlo]

It works! Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.