Thread: Finding last non-empty column in row...
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mika[_3_] Mika[_3_] is offline
external usenet poster
  
Posts: 2
Default Finding last non-empty column in row...
This code works fine:
MsgBox Cells(Rows.Count, "A").End(xlUp).Row

But this does not:
MsgBox Cells(Columns.Count, "2").End(xlLeft).Column

Any ideas how it should be changed to work?

Thanks!
Mika.


Reply With QuoteReply With Quote