🚀 go-pugleaf

In article <1992Aug12.174812.15658@cbnewsk.cb.att.com> ayf@pruxp.att.com (Avi
Feldblum) writes:
>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
>

I'll be happy to respond to you via internet (I don't have mail access), but
cannot commit to giving phone advice.  (I'm a consultant and get paid for my
time.)

In answer to your specific problem, try turning error checking off,
"=ERROR(FALSE)", immediately before pasting, then back on again.  This usually
supresses Excel's messaging.

More importantly, using COPY()/PASTE() in macros really gums up the works.  Try
using the OFFSET() function instead.  It effectively copies and pastes, but is
MUCH faster.

Good luck!

-- Sparky