On Tue, 8 Feb 2005 11:14:43 -0600, "scott" wrote:

It now checks the cells, but IsNumeric() returns True for empty cells, why
does that happen?

Because a blank can be evaluated as a number.

If you want to look for a number being present, as opposed to contents which
can be evaluated as a number, try:

application.WorksheetFunction.IsNumber


--ron