code for col number of last used cell in a row

[Jack Sons]

Hi all,

I knew it once, but I didn't program for a long time:
What is the best code to get the column number (number!) of the last non
blank cell in a row?
TIA

Jack Sons
The Netherlands

 

[Bob Phillips]

Assuming row 1

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

 

[ozgrid.com]

Dim lCol as Long

lCol=Cells(1,Columns.Count).End(XlToLeft)).Column

 

[Mike H]

Hi

The 1 represents row 1 so change to suit

LastCol = Cells(1, Columns.Count).End(xlToLeft).Column
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Jack Sons]

Bob, Dave and Mike, thank you all.

Jack.