View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder[_4_] Rob van Gelder[_4_] is offline
external usenet poster
 
Posts: 1,236
Default VB coding to go to last cell at end of any given row?

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!