Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How stop the "started office live" pop-up to stop. it is checked | Excel Discussion (Misc queries) | |||
Stop % in red | Excel Worksheet Functions | |||
How do I stop other circles in other cells to stop selecting? | Excel Worksheet Functions | |||
How do I stop other circles in other boxes to stop selecting? | Excel Worksheet Functions | |||
Macro: With Stop it works. Without Stop it doesn't. | Excel Programming |