Before I explain my problem, here is some background info:  
-   I use a formatted excel spreadsheet as an invoice which I send t
 customers via email.
-   The invoice number in the spreadsheet is the same as the name o

I have gone through previous posts but could not get the correct/similar code
for:-
1.when  command button(1) is clicked, 10 rows down (if hidden) from  an
active  cell should be unhidden i.e. if B4 is active cell, rows 5 to 14

I need to check data in a range of 100 cells.  The value can be blank or
single character only from these upper case letters (A, B, C, N, P, R, S, T,
X, Y, Z). If the data is not correct prompt user to fix it.  Is there better
way to validate the cells that multiple if ..then .. ...

Sorry to be a pain about this.  The custom toolbar I created is displaying
when the workbook opens and hidden when the workbook closes, which is fine.  
I then wanted to copy the workbook to another location with another name, and
attached the toolbar to the new workbook.  However ...

Hello together.
How can I create an assoc array in excel via vba?
Should be something like this:
myArray("cats") = 1

A usefull code is working with .Controls
eg I have several txtboxes named txtHallo1 txtHallo2 ...
for iCH = 1 to ...
Me.Controls("txtHallo" & iCH).text

I have posted some code below, it sorts the sheet within the rang
everytime a value is changed putting the highest value at the top, th
trouble is when it performs this the screen flickers while it
calculating no matter what i do!!!!, is there a way of doing what

The proc below is a general search called by other procs.
The IAllRtesOrOne input var determines if one or more sheets
will potentially be searched.
At issue are code lines A B C or A D E as described below,

good day!
i need a excel formula that counts FAC, 1,SL or VL as 1.
FAC    1    SL
FAC    1    SL

I have this situation and I hope someone would be able to give me some
advise about how to tackle it.
I have a program that produces reports in CSV format.
Users view the CSV files using Excel.

Hi, I am having a little trouble with this code. It produces a runtime
error 1004 in VBA. I think it is coming from this line of code. Would
appreciate any help with this.
Thanks,

How does one convert dates that were entered in a date data type format then
erroneously turned to Julian format by copying them into a general or text
data type feild back to the correct date format?

I am trying to use the linest function to find a sixth order polynomial
for a data set of 10 samples in VBA. When I run the code below, I get
an error number 16, "Expression too complex". Any ideas about why the
expression is too complex for VBA, but not too complex for a

Not sure if this is the right newsgroup.  If not could someone direct me to
the right group.
I'm having problems with a Worksheet that I created.  Its a bit tricky and
was wondering if there is anyone here that is good with Excel give me a hand

I have an Excel file that contains tick and cross images that are
sourced from the web, and I was wondering if there was a way to extract
the URLs of the images with VB? I checked the MSDN but there doesn't
seem to be a SourceName property for the object.