I wrote an Excel 2003 Add-in using VBA and distributed it to someone
using Excel XP (Excel 2003).
Whenever my client uses the app I am getting the following error when
the Mid function is encountered --

Does anyone know how to change a large matrix into one column?
Like this:
abc
abc

I have a program (see program below) that sometimes takes several minutes to
run .
I wonder if there is any way to speed up the program.
Thanks in advance.

I am trying to use a variable that was declared as “Public” at a Module
level in one workbook, in a second workbook. I know I need to use a
“Set” statement, but so far I have not come up with the correct
combination to make it work. I am relatively new to VBA and would

I saw in a vbe of an XL2K sheet some time back that the modules had
different names instead of the usu. module1, module2, etc.  I checked around
and looked in properties, etc., but haven't found where to do this.  Can
anyone point me in the right direction?

I don’t even know where to start.  
What I need to do is a lookup based on an Excel spreadsheet:
show result in B2 based on Criteria in C2
but the lookup done from a Access Database Table based on

I would like to print a simple summary report (on one tab) for each record in
a list of 400 records (on a separate tab)...  Any relatively simple ideas?
The report use a vlookup to get the data for the record, but I don't know
how to update the vlookup formula with the next record ...

what's wrong with this code? "list" is a named range.
Code:
--------------------
 Private Sub Test()

In Excel, I would like a cell to automatically insert a letter when it is
clicked or active.  

Hi a very easy one:
sub gtt()
for a=1 to 10
cell(a,1)=cell(a,1)+cell(a,2)

I found a great piece of coding in the archives for taking care of filters
in protected workbooks.  My difficulty lies in that the sheets all have
different names and I don't know how to code for all sheets in a workbook.
Here's the code to put in the workbook module:

This program will take a sheet and send it as an embedded email.  It
works perfectly in a workbook with worksheets (sheet1)(sheet2)(sheet3)
For some reason when I enter this code into a workbook I actually need
to use it for whos worksheet name is (Recap) it sends the email just

I have named cells that are either single cells of ranges.
I need to detect, using VBA, is those named cells are empty or any
value, INCLUDING formulas that would (incidently) return "" !!
I've been scouring google for the answer to no avail :(

I'm creating a new workbook based on data from an old workbook.
OR i can create a new worksheet in the same workbook.  I need some help with
VB programming as I'm not great at it.... I can understand code but always
have trouble starting it up.

Can someone tell me how to use i.e. sum for pounds and ounces.
Also how you could remove two minimum figures from a list.
I would like to use Excel for this.
Regards