Xref: utzoo comp.sys.mac.programmer:10096 comp.sys.mac:41371
Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!cs.utexas.edu!tut.cis.ohio-state.edu!ucbvax!agate!usenet
From: gangof4@violet.berkeley.edu (john steggall)
Newsgroups: comp.sys.mac.programmer,comp.sys.mac
Subject: Simple Excel Macro Problem
Summary: Help!
Keywords: excel, macro
Message-ID: <1989Nov1.092420.9034@agate.berkeley.edu>
Date: 1 Nov 89 09:24:20 GMT
Sender: usenet@agate.berkeley.edu (USENET Administrator;;;;ZU44)
Distribution: usa
Organization: University of California, Berkeley
Lines: 25

Dear friends,
 
I've got a *really* simple problem with an Excel macro.  I've had
very little experience doing excel macros and have found little
useful documentation in the excel docs or books I've seen (anyone 
have a suggestion for books on excel macros?)  

Anyway, here's the problem:
 
I'd like to pass the macro a range of cells (e.g. A1:A50) and have it 
count the number of cells which contain a specific value and then return
that number.  Specifically, I'm trying to count the number of cells
that have zeros, in a single column of data.
 
I can do it if I create a database of the cells in
question but this is not appropriate for my particular spreadsheet.
I've spent numerous hours on this one and haven't had any luck.
I think that I must be doing something really stupid because I
can't do anything with a selection range, at least with the macro.
This is driving me crazy and holding up *vital* research (ha!).  Any
ideas?
 
- john steggall -
gangof4@violet.berkeley.edu
(415) 643-8927 (lab)