Thread: Small macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Auric__ Auric__ is offline
external usenet poster
  
Posts: 538
Default Small macro
On Wed, 19 Nov 2003 21:45:22 -0800, wrote:

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

Use the ISNUMBER formula. Put this in AD8:
=ISNUMBER(A8)
and copy it down.
--
auric "underscore" "underscore" "at" hotmail "dot" com
*****
Danger! Human at keyboard!
Reply With QuoteReply With Quote