View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andrius B. Andrius B. is offline
external usenet poster
 
Posts: 4
Default 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.