I am trying to get information from an excel doc that is closed, copy
it, and paste it into the excel doc that i am working with.  This is
what i have and it seems to work until i hit the final step when i get
an error message saying "Object doesn't support this porperty or

Good Day:
I am using Excel 2002 SP3 and this will tip my hand and show how little I
know about the program.  I'm having a problem with charting.  I have a data
sheet tied to a chart.  The data sheet has all dates from 12-31-2007 through

I was wondering if it is possible to write a macro for the following
situation and if so how?
Basically we have 2 tables with various formulas in its cells, each table
yields different results based on the formulas. Outside of the tables we have

I am pretty new to formulas and such and don't have a very good understanding
of them.  Here is what I am trying to do.
I have two Excel worksheets.  Both files have a column in common, but one
worksheet doesn't contain a complete list of the same information that

i want to print a report of 10 page. i want subtotal on every page while
printing like page 1 of 10 2 of 10

Problem:
In Excel 2007 an xls workbook takes 2-4 seconds to recalculte whenever a
cell is changed. The workbook works fine in Excel 2003.
No external links

I have a worksheet to which I'm trying to associate data in cells on
other sheets.
The data is being put into cells A5-A10, B5-B10 though to I 10 in the
end - that's 54 cells on 27 sheets to populate the D column in this

I have the following formula,
=IF(G5=2000,(SUMPRODUCT((Detail!$A$6:$A$10000=C5)*(Detail!$E$6:$E$10000=G5)*-1,Detail!$O$6:$O$10000)),IF(OR(E5=6,E5=21),(SUMPRODUCT((Detail!$A$6:$A$10000=C5)*(Detail!$G$6:$G$10000=G5),Detail!$O$6:$O$10000)),SUMPRODUCT((Detail!$A$6 ...

I have placed numerous clipart images on a worksheet.  When I define the
print area and then scale it upward by 130 percent to fill a page, the
clipart images are all shifted downward by about one-tenth of an inch.  This
shows up on the print preview as well as the printed page.  ...

While I'm not new to Excel, I am new to using conditional formatting,
functions and macros within Excel. I'm working on a sheet that tracks certain
data on new hires. We track this data for 3 consecutive 30 day periods. I
want to create two macros that will make things easier for ...

The list of recently opened files appears to retain paths to files that
no longer exist on the system. Is there any way to change this, or to
remove files that no longer exist?

Guys,
I suspect we have a problem comming from the SP3 of Office 2003.
The text import wizzard has some kind of internal logic to dynamically
select the File origin (code page).

I have inherited an Excel workbook with several worksheets containing
charts that get their source data via MSQuery from an Access
database.  The users require that this stay in Excel so I have to find
a way to make it work.

I was just looking at
http://msdn2.microsoft.com/en-us/library/bb224771.aspx, which states, in
reference to the XIRR function:
"Dates should be entered by using the DATE function, or as results of other

I'm trying to find th fourth blank cell in a column and select a range based
on it. Should be simple but for some reason I can't makeit work. Anyone tell
me what I'm doing wrong? I'd be most grateful.
For background, I have some data followed by two blank cells, followed by