Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
For Statement
Good morning,
I have the code below, and the code works fine. However, the problem is the code checks problem defined names and messages the user individually, and it would not check the next defined name unless one is corrected. For example, I have two problem defined names: "A000PPLE" and "O000RANGE". The code would alert the user on "A000PPLE" first, and the code would not alert the user on "O000RANGE" unless the defined name "A000PPLE" is corrected. Is there a way to change the code below to alert the user all the problem defined names so that the user can write down all the problem defined names all at once and does not have to wait for another one unless one is fixed? Thanks. For Each nName In ActiveWorkbook.Names If Len(nName.Name) < 8 Then MsgBox "Please check and correct the defined name '" & _ nName.Name & "' (" & Right(nName.RefersTo, Len(nName.RefersTo) - 1) & "). " & _ "The defined name must have 8 characters long and must be corrected " & _ "in order to proceed further.", vbCritical GoTo TheEnd End If Next nName GoTo NoErrors |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
Using an IF statement, or VLOOKUP statement | Excel Programming | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions |