Find the first empty column

[Simon]

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

 

[Norman Jones]

Hi Simon,

Try:

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

 

[Nigel]

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

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

Cheers
Nigel

 

[Guest]

Thanks,

'ToLeft' - I was using 'Left'

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

Try:

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

---
Regards,
Norman






.