ExcelBanter - Set ActiveCell at the first column of the same row...

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Set ActiveCell at the first column of the same row... (https://www.excelbanter.com/excel-discussion-misc-queries/227919-set-activecell-first-column-same-row.html)

Dave

Set ActiveCell at the first column of the same row...

Is there a simple command that will set the ActiveCell to the first column of
the same row that ActiveCell is currently in?

I can't use Offset because I the current column varies.
--

Thanks,
Dave

Mike H

Set ActiveCell at the first column of the same row...

Hi,

Cells(ActiveCell.Row, 1).Select

Mike

"Dave" wrote:

Is there a simple command that will set the ActiveCell to the first column of
the same row that ActiveCell is currently in?

I can't use Offset because I the current column varies.
--

Thanks,
Dave

Dave

Set ActiveCell at the first column of the same row...

THANKS!
--

Thanks,
Dave

"Mike H" wrote:

Hi,

Cells(ActiveCell.Row, 1).Select

Mike

"Dave" wrote:

Is there a simple command that will set the ActiveCell to the first column of
the same row that ActiveCell is currently in?

I can't use Offset because I the current column varies.
--

Thanks,
Dave

All times are GMT +1. The time now is 03:44 PM.