Thread: code for col number of last used cell in a row
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
  
Posts: 834
Default 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





Reply With QuoteReply With Quote