| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validata a variable
I need to validate a cell contains only numbers from the 3rd position to the
forth. I have below statement to convert to number but if there is an alfanumeric value the macro fails. myVal = Mid(wb.Sheets("AOS Form").Range("Q2").Value, 3, 4) * 1 How do I do it? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assigning a Variable to an Expression that Includes a Variable andVBA Property | Excel Programming | |||
| Nothing Keyword Destories Objects rather than just resetting the variable to an empty variable | Excel Programming | |||
| why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
| Run-time error '91': "Object variable or With block variable not set | Excel Programming | |||
| Cells.Find error Object variable or With block variable not set | Excel Programming | |||
![Alberto Ast[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
