Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Identify offending cell
I have these codes below. What I want to do is to identify in a message box
which cell has the error. So if I have text in cell A3, I want the message box to tell me the error is in A3. Any ideas? Sub ErrorExample() On Error Resume Next Dim total As Integer Dim intA As Integer Dim intB As Integer Dim intC As Integer intA = Range("A1") intB = Range("A2") intC = Range("A3") total = intA + intB + intC MsgBox ("Total is " & total) End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If Formula to Identify Cell | Excel Discussion (Misc queries) | |||
Identify the Current Cell | Excel Discussion (Misc queries) | |||
how to identify a cell address | Excel Programming | |||
Cell Ref to identify worksheet | Excel Programming | |||
pdf printing OFFENDING COMMAND: STACK: | Excel Programming |