code for col number of last used cell in a row
 

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

code for col number of last used cell in a row
 

Assuming row 1

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

--

HTH

Bob

"Jack Sons" wrote in message
...
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

code for col number of last used cell in a row
 

Dim lCol as Long

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



--
Regards
Dave Hawley
www.ozgrid.com
"Jack Sons" wrote in message
...
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

code for col number of last used cell in a row
 

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" wrote:

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



.

code for col number of last used cell in a row
 

Bob, Dave and Mike, thank you all.

Jack.

"Jack Sons" schreef in bericht
...
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