How do I declare a multidimensional array where the first dimension  
upperbound is known, but the second dimension upperbound is not known ?  
Also, how do I 'redim' that array when the second dimension upperbound is
known?

I would like to create a macro to setup Rows to Repeat at the Top based on
the current rows selected.  ie I would just select the rows and I plan on
using a menu bar macro button to run the macro.  Therefore the macro needs to
know to use the currently selected rows to use as the ...

I need to convert the date 22/03/08 which is dd/mm/yy to what day it is which
is Saturday.  Is there a function that does that?  Or how can I do what I
want?
Thanks

If the SeriesCollection Object on the chart has all values contained within
it as "#N/A", then the object effectively becomes invisible from the code
and when attempting to set the values to it again via code, it errors out as
the code can't see the object on the Chart Object ...

Using Excel 2000.
I need to insert a number of rows and using the following code seems wrong
insomuch that the code is repeated for the number of rows required, is there
a more simple solution?

I have some charts using the data below.  I want to have one column showing
four (4) colors on top of each other for critical; high; medium and low.  Can
do
Jun-07    Critical    High    Medium    Low    Unknown    TOTAL CRs Created    TOTAL CRs Closed

I have read some of the thread on VSTO but none seem to address my specific
concerns on using shape objects and one of the VSTO MVP's sent me to the
"Excel specialists" here.  Please see below and offer what you can.
-----------------------------------------

WorksheetA (http://www.specialty-risk.com/Spreadsheet%20Help/WorksheetA.xls)
is the worksheet created by QuickBooks.
WorksheetB (http://www.specialty-risk.com/Spreadsheet%20Help/WorksheetB.xls)
is a worksheet I use to keep track of monthly info, I also update the SS#

While recording a macro:
1) a *.txt file is opened
2) after opening the file a "FIND where ANY =" is used then I click on FIND
ALL

I have a workbook with one worksheet and a userform.
The userform is loaded by clicking a button on the worksheet and it has on
it textboxes for information to be entered.
The information that goes in these textboxes is often source from other open

Apparently some of our users are trying to run our workbook in
Internet Explorer instead of in Excel. Works fine with some other
workbooks but not with the code in our workbook.
We don't have the time to try to get it to work in Internet Explorer

I am trying to export 1 sheet to a new workbook with a specific save as
filename.  The filename is created by the excel worksheet in a specific cell.
The issue I have now is getting Excel to save the file as an excel workbook.
The following code works except it does not specify ...

Hiya,
I have this in cell A319:
=ADDRESS(MATCH(Date,A1:A312,0),MATCH(Name,A1:AF1,0),4)
Which, just as an example returns B312.

How can you guys add to the following macro :
Dim Test_1
Dim Count_Test_1
               Test_1 = Range("B5", "B" &

I have a value in columnB say 3042.
In columnC, I am multiplying it with 20/100 say =3042*20/100 = 608.4
Result in columnD is 3042-608=2434.
When I copy & paste values in columnE, it yeilds 2433.6 but I want