I would like a function similar to below, but for the
first empty column within row 36.

Below is what I use for the first empty row.

last_row = wks_Stock.Cells(Rows.Count, 1).End(xlUp).Row


Thanks,

Simon

Hi Simon,

Try:

Cells(36, Columns.Count).End(xlToLeft)(1, 2)

---
Regards,
Norman



"Simon" wrote in message
...
I would like a function similar to below, but for the
first empty column within row 36.

Below is what I use for the first empty row.

last_row = wks_Stock.Cells(Rows.Count, 1).End(xlUp).Row


Thanks,

Simon

Take a look here to cover all angles when finding the last row/column.

http://www.beyondtechnology.com/geeks012.shtml

Cheers
Nigel

"Simon" wrote in message
...
I would like a function similar to below, but for the
first empty column within row 36.

Below is what I use for the first empty row.

last_row = wks_Stock.Cells(Rows.Count, 1).End(xlUp).Row


Thanks,

Simon

Thanks,

'ToLeft' - I was using 'Left'


-----Original Message-----
Hi Simon,

Try:

Cells(36, Columns.Count).End(xlToLeft)(1, 2)

---
Regards,
Norman



"Simon" wrote in
message
...
I would like a function similar to below, but for the
first empty column within row 36.

Below is what I use for the first empty row.

last_row = wks_Stock.Cells(Rows.Count, 1).End(xlUp).Row


Thanks,

Simon


.