On Thu, 12 Apr 2007 00:21:55 -0400, "Gary Keramidas"
<GKeramidasATmsn.com wrote:

maybe this

Sub test()
If ActiveCell.Column < 1 Then
ActiveCell.Offset(0, -1).Select
End If
end sub

Super. It seems to work perfectly. I keep going left till it stops
yet no error comes up which is great.

Thanks. :oD

Gary


"StargateFan" wrote in message
.. .
I always seem to come across interesting things as I make up new
workbooks. I'm using the following code to allow user to step to the
left:

ActiveCell.Offset(0, -1).Select

Butt when user gets to A1, if the button is pushed again by accident,
an error box comes up because the first cell is reached:

Run-time error '1004': Application-defined or object-defined error

Is there any way to stop this error popping up? Any advice re this?
Even a message saying "you can't go any further to the left", heck,
whatever works <g.

Thanks. :oD