For row 1 - change 1 as required:

Lastcol = Cells(1, Columns.Count).End(xlToLeft).Column + 1

"saziz" wrote:


Hi all,

I was wondering what the syntax would be for last column.
Like I have for lastRow:

lastRow = .Range("B" & Rows.count).End(xlUp).Row

I need something similar for looking an first empty col. to the right.
Pleae help.
Thank you
Syed


--
saziz
------------------------------------------------------------------------
saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350
View this thread: http://www.excelforum.com/showthread...hreadid=494676