IF IS NUMBER THEN

[filo666]

Hi, an easy one, how to make a sub that chek if some value is numeric or text
if cell(a,b)=" any number???" then
tralala lalala lalala
end if

[Bob Phillips]

If IsNumeric(Cell(a,b).Value) Then

--
HTH

Bob Phillips

"filo666" <filo666@discussions.microsoft.com> wrote in message
news:137ED108-EC02-434D-A28B-3A4D8DC0F217@microsoft.com...
> Hi, an easy one, how to make a sub that chek if some value is numeric or
text
> if cell(a,b)=" any number???" then
> tralala lalala lalala
> end if

[filo666]

thank you very much

"Bob Phillips" wrote:

> If IsNumeric(Cell(a,b).Value) Then
>
> --
> HTH
>
> Bob Phillips
>
> "filo666" <filo666@discussions.microsoft.com> wrote in message
> news:137ED108-EC02-434D-A28B-3A4D8DC0F217@microsoft.com...
> > Hi, an easy one, how to make a sub that chek if some value is numeric or
> text
> > if cell(a,b)=" any number???" then
> > tralala lalala lalala
> > end if
>
>
>