How to find ###### in a cell

[Javier Pi Paredes]

Hi to all the group

Mi problem:
If the cell width is too small to display the data inside, how do I
know that I have some cells in the sheet displaying "#######".

Thanks in advance

Javier Pi Paredes
Santiago, Chile

[Javier Pi Paredes]

Thanks John

It work's very good!

John Green wrote:

> Hi Javier,
>
> Try something like the following:
>
> Dim rng As Range
> For Each rng In ActiveSheet.UsedRange
> If IsNumeric(rng.Value) And Left(rng.Text, 1) = "#" Then
> MsgBox "Column too narrow for " & rng.Address
> End If
> Next rng
>
> HTH,
>
> John Green - Excel MVP
> Sydney
> Australia
>
> In article <3765851A...@eclac.cl>, Javier Pi Paredes wrote:
> > Date: Mon, 14 Jun 1999 18:41:30 -0400
> > From: Javier Pi Paredes <j...@eclac.cl>
> > Subject: How to find ###### in a cell
> > Newsgroups: microsoft.public.excel.programming

[John Green]