How to know the right most column?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear all,

I would like to know how to get the right most column number whose cell has
a value in a row. Can anyone suggest how to do it programatically?
Thanks a lot.

Ivan
 
Hi Ivan,

For a specific row, try

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

MsgBox LastInCol

Replace 1 with the required row number.
 
Hi Ivan,

Try:

With ActiveSheet.UsedRange
MsgBox .Column + .Columns.Count - 1
End With

HTH
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Loop from left to the right 5
Is there a method to find distinct values in a column 5
Finding right-most cell. 5
Call Macro using right click menu 3
How to locate a cell with dynamic column value 2
Column number of last column that returns value ignore formulas 8
How to get the row number of new value in a column??? 1
Excel How to find the most common pairs and triplets numbers? 5

Back
Top