ExcelBanter - Activating the next cell

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Activating the next cell (https://www.excelbanter.com/excel-programming/342070-activating-next-cell.html)

Bhupinder Rayat

Activating the next cell

Hi all,

A very simple question to the vba whiz kids out there.

How do i activate the cell to the right of the active cell?

Regards,

Bhupinder

Harald Staff

Activating the next cell

Hi Bhupinder

One of those two:
ActiveCell.Next.Activate
ActiveCell.Offset(0, 1).Activate

HTH. Best wishes Harald

"Bhupinder Rayat" skrev i melding
...
Hi all,

A very simple question to the vba whiz kids out there.

How do i activate the cell to the right of the active cell?

Regards,

Bhupinder

All times are GMT +1. The time now is 01:15 AM.