🚀 go-pugleaf

In article <1992Aug10.153521.20679@nrtpa038.bnr.ca> Sparky writes:
>
>If that's not it, please post some sample code and I'll try again.

Hi,

I'm new to this group and am looking for some excel guru's to ask
questions of. Here's a basic description of what I am trying to do and
if anyone thinks they may be able to give me a hand I would appreciate
it.

I am using Excel 4.0 for Windows. I've set up a workbook (.xlw) that
contains (at least) four files. One is a macro sheet that contains all
the macros that I need to use, cmodel.xlm, the second is a database of
parts, parts.xls, the third is the spreadsheet that the user wants
filled out, product.xls, and the fourth is just a README file to give
some info on what the workbook does and to use it.

The basic mode of operation is that the user will list a sequence of
numbers in column A of the worksheet, and then run a macro that copies
a series of formulas across the row based on the "class" of the number
(e.g. 0, <1000, <10000), then takes the actual number and goes out to
the database worksheet and extracts some data that relates to that
specific part.

One problem I am running into now is that the formulas may depend on
something like a tax rate, so I would like to define that as a defined
name and then the formula would be something like say
F23*Tax_Rate. What I am finding is that each time it copies that
formula in, it askes me if I want to use the existing definition of
that named variable. If there are 30-100 such lines and several such
variables it drives one crazy. 

So if you have experience writing macros in excel and would be willing
to answer some questions, please let me know. If you are willing/able
to respond to emailed questions or take a phone call, please let me
know.

Thanks in advance.

Avi Feldblum
AT&T
avi_feldblum@att.com
215-939-3748