| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can I move the cursor on error??
I have my project inventory sheet working other than a divide by 0 error #DIV/0! when they don't enter a value in the quantity field.
Is it possible to move the cursor to the quantity field and display a message with this error? Or, is it time to start learning VB? This is the code that calculates the sales margin and gives the error =IF((G4+H4)0,(I4-F4)/I4,0) The quantity cell is D4 Thanks for your help, Les |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| move cursor on one sheet moves cursor on all sheets | Excel Discussion (Misc queries) | |||
| How do I get tab to move the cursor one cell over rather than 8? | Excel Worksheet Functions | |||
| Several questions about move cursor | Excel Discussion (Misc queries) | |||
| Move cursor to next row | Excel Discussion (Misc queries) | |||
| Move Cursor to A1 | Excel Discussion (Misc queries) | |||
Threaded Mode
