code to select a cell

[Phil-e]

Cant find this. I need code to move from one cell to another after data is entered. when I use [ Range ("C9").Select ] (as an example - without brackets) cell c9 is selected but when I try to move off the cell I can't. I am trying to unhide columns as I need them by entering data into different cells. I have that working fine and I would just like to be able to move to the next cell automatically.

Thanks in advance

 

[tactps]

You can do this:
[c9].select
...code here
[c10].slect
...code here

but "selecting" is resource hungry.

You can do almost anything without having to select it first.

Post your code, or explain in more detail what you want to do.

 

[Tazguy37]

move from one cell to another after data is entered. when I use [ Range ("C9").Select ] (as an example - without brackets) cell c9 is selected but when I try to move off the cell I can't.

Do you have code to post that you're currectly using? Are you entering data on a userform?

And I don't quite understand why you can't .Select another cell or use the cursor keys to manually scroll to another cell to enter data.

 

[royUK]

This will move cells

 ActiveCell.Offset(0, 1).Select    ' next right
    ActiveCell.Offset(1, 0).Select    ' next down

You probably need to unhide colums first though.It's not clear what yo are doing. Entering data with code doesn't usually need the cells to be selected as has been pointed out.I don't follow the bit about unhidin