Menu

Small macro

Search this Thread

Prev

Previous Post

Next Post

Next

#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 Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SMALL IF	Adam	Excel Discussion (Misc queries)	4	October 2nd 09 01:46 PM
ISERROR,SMALL,INDEX, MATCH, SMALL??	M.A.Tyler	Excel Discussion (Misc queries)	1	May 2nd 07 04:08 AM
Using Small	PH NEWS	Excel Worksheet Functions	2	July 27th 06 09:22 AM
Small	tom	Excel Discussion (Misc queries)	2	July 11th 06 05:46 PM
Newbee needs HELP-Small Macro	tbobo	Excel Discussion (Misc queries)	4	March 8th 06 07:17 AM

All times are GMT +1. The time now is 06:09 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement