Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding only numeric values in a worksheet using vb.net?
Hi all.
Maybe smb could make an advice how to do this: I have to find all the rows in a Excel worksheet, which contain cell with a 11 digit numeric value. E.g. two rows each with 3 cells with values: ------------------------------------ Will | Smith | 4524574561 Gerry | Smith | LowStreet 20 ------------------------------------ So, the first row should be accepted, and the second - ignored. I tried different examples using oSheet.Cells.Find(What:=... but unsuccesfully. Is there a way to use regular expressions Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding NEXT to last, non zero numeric value in a row | Excel Worksheet Functions | |||
TO DELETE ONLY NUMERIC VALUES IN A CHARACTER AND NUMERIC CELL IN | Excel Discussion (Misc queries) | |||
finding only cells with a numeric value | Excel Discussion (Misc queries) | |||
Return Numeric Labels that have different Numeric Values | Excel Worksheet Functions | |||
Finding the mode (alpha numeric) | Excel Discussion (Misc queries) |