Cell Types

[Kaval]

I am looking for the VB equivalent to the cell type function. That is, I need
to determine if a particular cell contains a formula, a number, text or is
blank.

I guess it has to do with SpecialCells but I cant work it out.

Thanks, Kaval

[Norman Jones]

Hi Kaval,

Try:

dim rCell As Range

If HasFormula.rCell Then ' Formula

If Application.IsNumber(rCell.Value) Then ' Number

If Application.IsText(rCell.Value) Then ' Text

If IsEmpty(rCell.Value) Then ' Empty


---
Regards,
Norman



"Kaval" <[email protected]> wrote in message
news:[email protected]...
>I am looking for the VB equivalent to the cell type function. That is, I
>need
> to determine if a particular cell contains a formula, a number, text or is
> blank.
>
> I guess it has to do with SpecialCells but I cant work it out.
>
> Thanks, Kaval

[Norman Jones]

Hi Kaval,

> If HasFormula.rCell Then ' Formula

Should be

If rCell.HasFormula ' Formula


---
Regards,
Norman



"Norman Jones" <[email protected]> wrote in message
news:%[email protected]...
> Hi Kaval,
>
> Try:
>
> dim rCell As Range
>
> If HasFormula.rCell Then ' Formula
>
> If Application.IsNumber(rCell.Value) Then ' Number
>
> If Application.IsText(rCell.Value) Then ' Text
>
> If IsEmpty(rCell.Value) Then ' Empty
>
>
> ---
> Regards,
> Norman
>
>
>
> "Kaval" <[email protected]> wrote in message
> news:[email protected]...
>>I am looking for the VB equivalent to the cell type function. That is, I
>>need
>> to determine if a particular cell contains a formula, a number, text or
>> is
>> blank.
>>
>> I guess it has to do with SpecialCells but I cant work it out.
>>
>> Thanks, Kaval
>
>