How to know the right most column?

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
 
N

Norman Jones

Hi Ivan,

For a specific row, try

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

MsgBox LastInCol

Replace 1 with the required row number.
 
G

Guest

Hi Ivan,

Try:

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

HTH
 

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

Is there a method to find distinct values in a column 5
Loop from left to the right 5
Call Macro using right click menu 3
Finding right-most cell. 5
How to locate a cell with dynamic column value 2
How to get the row number of new value in a column??? 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How to detect row number of selected cells? 1

Top