MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Moving about macro


Posted by Penfold on January 10, 2001 3:40 AM

Help me please, this is driving me to distraction, i need a macro that moves to the right one cell then down one cell but without "Selecting" a cell

thanx


Posted by Dave Hawley on January 10, 2001 3:43 AM


Hi Penfold

Here you go:

Sub TryThis()
ActiveCell.Offset(1, 1) = "Hello"
End Sub


Any other probs, just yell.

OzGrid Business Applications