Moving between cells without using "select"

[cmb80]

Hi all, I have 3 formula's that I need to paste into cells. Currently I use the select function to select the cell, and then active cell.offset to move to the left (as below).

Is it possible to move between cells without using select as I understand this is not good practice

Please Login or Register  to view this content.

[Kyle123]

Please Login or Register  to view this content.

[zbor]

Try this:

Please Login or Register  to view this content.

[Norie]

Perhaps.

Please Login or Register  to view this content.