A bit short on details. You don't have to move the cursor to operate on a
range.

Sub colorit()
Dim rng As Range
Set rng = ActiveSheet.Range("A10")
If rng = "Total" Then
rng.Interior.ColorIndex = 3
End If
End Sub


Gord Dibben MS Excel MVP

On Mon, 1 Jun 2009 16:03:01 -0700, HpyTrvlr69
wrote:

I would like to know the easiest way to move the cursor wround in the a
spreadsheet in order to change the focus of the cursor. I am trying to move
the sursor to a location determined by an 'if' statement and do some
formatting. Not having any "Logic Luck"