selecting the cell to the right

[mani_singh]

how can i select the cell to the right in a macro?? i want to runa command in the cell to the right of the one i'm in after a caommand has taken place there

i.e.

1st command run in col b following by selcting the col c and running another command there

thanks everyone!

 

[VoG]

ActiveCell.Offset(0, 1).Select

but you do not need to Select a cell to work with it.

 

[mani_singh]

ok then maybe you can help me. i have a command which types "successful" into col B, i need to select col C directly next to it and have it type the formula "=lastauthor()" into it.

the last author command is pre-setup so it should populate with the info when typed!

 

[VoG]

Assuming that the cell in column B is the active cell then try

ActiveCell.Offset(0, 1).Formula = "=lastauthor()"

 

[mani_singh]

if it isnt how can i ensure that the cell is the active one?

i.e. at the end of the macro command which works on that cell in col b can i put a command which keeps active there?

 

[VoG]

Please can you post your code, or at least the part that puts "successful" in column B.

 

[mani_singh]

sure:

Sheets("log").Select
LR = Cells(Rows.Count, "B").End(xlUp).Row
Cells(LR, "B").Value = "Successful"

I NEED THE COMMAND HERE!

End Sub

 

[northwolves]

Sub macro1()
If ActiveCell.Column = 2 Then ActiveCell.Offset(0, 1).Formula = "=lastauthor()"
End Sub

Best Regards

 

[VoG]

Cells(LR, "B").Offset(0, 1).Formula = "=lastauthor()"

 

[mani_singh]

Sheets("log").Select
LR = Cells(Rows.Count, "B").End(xlUp).Row
Cells(LR, "B").Value = "Successful"

I NEED THE CODE HERE thank you

End Sub