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.

something like this???

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

To find the right most populated column in row 1
--
HTH...

Jim Thomlinson


"carl" wrote:

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.

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).Sel ect

This is not necessarily the last column used in the current row.
--
Ian
--
"carl" wrote in message
...
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.

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

"Ian" wrote:

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).Sel ect

This is not necessarily the last column used in the current row.
--
Ian
--
"carl" wrote in message
...
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.