Go to last column

[Guest]

Can someone please tell me how to make the cell in the last column of a table
of data active? So I can get it to find the correct row by setting it to
find a particular string of text. But I need it to then go from column A in
that row to the last column with any data in it. This is for a table that
has figures that get added on every month.

 

[Guest]

something like this???

Cells(1, columns.count).End(xlToLeft).Select

To find the right most populated column in row 1

 

[Ian]

Your request suggests you are currently in the row you need and you want to
go to the last column with data in ANY row.

Cells(ActiveCell.Row, Cells.SpecialCells(xlCellTypeLastCell).Column).Select

This is not necessarily the last column used in the current row.

 

[Guest]

Hi Jim/Ian,

Jim - The text you provided actually takes me to cell A1. So it basically
takes me back to the start rather than to the last column.

Ian - I don't want to get to the last column with any data in it. I want to
get to the last cell in the row that I am currently in. So say that we have
Junes figures in column F and the active cell is A3. I want to get to F3.
But at any particular time I could be in any row so I just want a very simple
piece of script that gets me to the end of the row.

Cheers