Small macro

  • Thread starter Thread starter rjc44
  • Start date Start date
R

rjc44

In A8:A24, I have formula's, the result of which produces
numbers(dollar amounts), text and blanks in the range.

How can I create a macro that inserts TRUE in cells
AD8:AD24 if cells A8:A24 contain a number and FALSE if
they do not.

Thankyou
 
In A8:A24, I have formula's, the result of which produces
numbers(dollar amounts), text and blanks in the range.

How can I create a macro that inserts TRUE in cells
AD8:AD24 if cells A8:A24 contain a number and FALSE if
they do not.

Thankyou
Click to expand...

Use the ISNUMBER formula. Put this in AD8:
=ISNUMBER(A8)
and copy it down.
 
-----Original Message-----
In A8:A24, I have formula's, the result of which produces
numbers(dollar amounts), text and blanks in the range.

How can I create a macro that inserts TRUE in cells
AD8:AD24 if cells A8:A24 contain a number and FALSE if
they do not.

Thankyou
.
Click to expand...
You can use a simple function in the cell you want True or
False to appear in. =IF(A8 > 0,True,False) and copy the
formula down the whole range of AD8:AD24.
 
Back
Top