Using XL2003...
I have a source worksheet that has numbers stored as text, with leading
zeros.
I load that worksheet into an array for faster processing

When we print a spreadsheet to our Unidrv-based printer, it appears that it
is printing at 1200 DPI. This is the Master Units setting for the printer. I
have not confirmed this, but the lines in the spreadsheet are only 1 pixel
wide.

Z6 is our index number. It can be either 1, 2, or 3. Putting numbers in an
array like this works:
=INDEX({1;1;0},Z6)
But I want it to pluck values from cells. So I tried this, which doesn't

I am attempting to sum a range (Range_i) and then insert the values
into a cell. I am receiving the Type Mismatch error. Any help would be
appreciated.
Bill

I have a table as follows:
Account    State 1    State 2    State 3    Week
ABC    12    13    141    1
XYZ    13    14    142    2

I try to learn how to write macros in excel. This is my first macro. I
have one problem. In a sheet I have few ComboBoxes which have
ListFillRange defined as an range of cells in another sheet (in the same
Workbook).

I recorded a macro for setting the interior color of a cell to the lightest
gray in the color palet on the toolbar.  But I need a lighter shade of gray.  
I experimented with various color indexes, but these indexes seem to only use
the colors from the color palet on the toolbar.  ...

Hi everyone, this is my first post. I would appreciate it if you tell
me how to do this in a more "elegant" way. I imagine that exist a more
sinthetic form to do this without specifying the range every time.
r is set previously in the code

Coded a relatively complex program.  When I execute the following -
   Workbooks("ACT-Reports.xls").Worksheets("Reports").Activate
It was working for a few weeks then the only way to do the same thing became -
   For Each bkTempBooKxx In Workbooks

How can I change the number of scrollable lines in the
VBE Immediate Window?  (Excel 2003; VBA 6.3.)

As subject, Thanks

I have an Excel spreadsheet that I am exporting data from  SQL server via DTS. the column in SQL is varchar and the column in Excel is text. But after the
export, in Excel the data is stored as "Number Stored at text" instead of text stored as text.
The same thing happens when I ...

I have written and run many macros in Excel 97 that when I try to run them in
Excel 2003 I get an error message, "Can't find project or library".  
My original system was a Window 2000 with Office 97 installed.  The new
system is Windows XP with Office 2003.

I'm creating an excel worksheet in  VB.NET
While setting the print properties , I was able to print the date on
the left footer
.PageSetup.LeftFooter = "Printed on " & Today.ToShortDateString

The below is a question that I asked on the Excel Discussion Group Board:
<-------------->
How can I add, subtracts, etc. (all functions) with a cell that has a
number-range.  How do I input a number range in currency mode in the first