Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
#NUM checking
Hi All,
I wrote a sub procedure that runs on a column(using 'offset') of data(Numbers calculated out of a formula) and checks a validity of them. in one cell of that column i recieve a "#NUM" error. How can i relate to that in my code? How can i check it and skip any entry that returns any kind of "#nnn" error? Thanks a lot..... Lp12 Im using Excel2003. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
#NUM checking
You can use the IsError function to check the the cell value: Assuming you
have the value of the cell in the VBA variable CellVal you could do something like this: If IsError(CellVal) ' put in code here to handle the error - ignore the value or replace it with something Else ' your existing code would go here End If "Lp12" wrote: Hi All, I wrote a sub procedure that runs on a column(using 'offset') of data(Numbers calculated out of a formula) and checks a validity of them. in one cell of that column i recieve a "#NUM" error. How can i relate to that in my code? How can i check it and skip any entry that returns any kind of "#nnn" error? Thanks a lot..... Lp12 Im using Excel2003. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spell Checking with checking cell notes | Excel Discussion (Misc queries) | |||
Checking and IF ? | Excel Worksheet Functions | |||
Day Checking | Excel Discussion (Misc queries) | |||
Checking Hyperlink | Excel Discussion (Misc queries) | |||
Add checking | Excel Worksheet Functions |