Excel XP, Win XP
Helping an OP.
The OP has a long column (5,000 - 10,000 rows) of mathematical formulas.  A
number of the values are "0" (numerical, not text).

I have a workbook with 4 sheets in. "Total", "2007", "2008" and "2009".
On the "Total" sheet cell
B1 contains "2007" and
B3 contains "='2007'!E3"

I want to update AGE field in file A from file b.  i.e update AGE.
The number of records in file A and File B are not equal and may be
different value.
this is what i want

If I want to reference a control by a string name I use:
  Me.Controls("Checkbox" & i).Value
So, in VBA code how do I display a User Form with the form name in a
string? Application.Run ?

Hi, I would like to concatenate a long range of cells using a semicolon to
separate each number.  I have come across several macros online that will do
this, but none have included a delimiter in the code and, unfortunately, I
don't know enough about VBA to make any modifications ...

In my project i have a before_save event with many contions and then if
all conditions are met i make a folder and name the file with info from
cell A1 ( if the file exist then it overwrites it).
Then i have a before_print event and i woulld like to save the file

I want to "send" a range (or, even better, an array) from Excel to the
middle of an existing Word document. Is this possible? The range I'm sending
has variable dimensions, so I'm thinking Mail Merge is not the way to go;
please correct me if I'm wrong.

I have been able to put together the code as follows with much help and
patience from the people of this site, alittle additional assistance would be
greatly appreciated the code works well until the if statement the then part.
the range("A3:G9") is filled over the period of one ...

Hi all,  
  The function below works fine, and it seems to run pretty quickly. I also
use it to find rows with data that are NOT at the very end of a worksheet.
#1.  As I become more familiar with with the Find method I wonder how much

Help!  I don't know what I did or how I did it, but I've somehow
changed some setting that is setting each cell in my worksheet as it's
own page.  I've tried moving the page breaks, but that doesn't do
anything.  It doesn't seem specific to the page either as all

I asked about this in a previous thread, and got some good references
to look at. What I'm hearing, without anyone saying so in so many
words, is that I can't modify a macro from a macro. Is that correct?

On another post to this group I found the following code, which creates
a case-sensitive unique list of items:
'Requires project reference to the "Microsoft Scripting Runtime"
Sub Test()

Hate to harp on about Lotus123, however it was possible to group
worksheets together so they stayed together unless using a command in
the tool bar. This meant when you formated the first sheet all the
others would be the same, plus most important was that if you went to

Though I understand Excel is a math system, and would see .1 and .10 as
the same number, my users do not.
The user gets data from suppliers, that shows:
Feet.Inches      x    Feet.Inches

I have MS Excel 2003 Pro.
Do I need some kind of reference to a library checked before I could use
GetSaveAsFilename? I am getting Run-time error '1004'.
Thhank you,