If there are gaps in the data, this approach may not work.
Try:
Cells(ActiveCell.Row, Columns.Count).End(xlToLeft).Select
--
Rob van Gelder -
http://www.vangelder.co.nz/excel
"R.VENKATARAMAN" $$$ wrote in message
...
activecell.end(xltoright)
see reference <end under vba help
StargateFan wrote in message
...
i.e., if one is on cell, say, D3, the code to go to M3, the last cell
in that row. Or, another example, If one is one cell E56 in a sheet,
coding to go to the last cell on that row of, say, T56? So what I'm
asking is that no matter where on any given row was in on, that the
coding take one to the end of that very row.
Thanks!