I have made a rather graphic interface for one of my models and in this
interface a use a lot of shapes, some of which I use as buttons. The problem
is that excel redraws all the shapes, even when for instants only one or two
shapes change color. This causes excel to run very ...

I'm working on a spreadsheet now, and I'm trying to pull out the
second largest value from a set of numbers.  For instance, let's say
that I have this series of numbers:
10

i have an app that exports excel graphs using "#import excel.h" directive,
now i'm converting the app to use a automation class generated by Microsoft
Studio 6.0 Class Wizard( that has all modules/properties ).
I'm having some trouble converting the line:

I have a query table with marked option: refresh data at startup (more and
less - sorry for my translation).
Normally there is a warning message when I open a file with autorefreshing
query tables (or pivot tables) and I can choose to refresh or not.

I have a table of columns, some titles, others costs.
Think I may need to email the files to someone to better demonstrate it.
Is it possible to create a macro button that will create an additional sheet
that summarises all the headings in column 1 and sums their respective costs

Any User using excel for Project Planning ? How can you calcuate Start
date and End date base on given Start date. The calcuation not include
Sunday and Saterday. Any Suggestion ?
Example

I was referred by Bob Philips to to the SUMPRODUCT array formula
method which works incredibly fast. But it look as if the formula does
not work with non-contiguous ranges, for exemple:-
=SUMPRODUCT(--((A1:A10,B1:B10)={"Ford","Chrysler"}))

In the Page setup dialogs, sheet tab, you can select Page Area , Rows
to report at top and Columns to repeat at left, by click the icon,
allow you select worksheet range. Is this methods can be apply on
VBA ? If yes how to apply on vba coding ?

I am working on a project involving the creation of custom Excel sheets from
VB.net. When anybody opens this file, I need only my ribbon to be displayed.
So, I went for setting startFromScratch to true.
What I have noticed is that when I use this, everytime Excel is started, I

This may seem strange, but I code in VBA but never created complex
functions on a worksheet itself.  Now it's driving me crazy trying to
embed functions in functions.
Is there some sort of trick there?  Outside in?  Inside out?

Waitin' 4 ur response

If I use the "as" function, the output does not include the "as"
header like it would if I ran the same query in sql. This is
particularly irksome when the column returns a result, like "count",
and the header is blank.

Is anyone here familiar with the Insert > Field control in Word.  I believe
there is a way to link Word to a range in Excel (in my case Column C).  I’m
trying to help my supervisor link some form letters that we have, to the data
in Column C (which contains identification ...

This is so strange I'm not sure how to ask.
I have a procedure that opens each workbook in a given folder. With
each workbook some code is applied. The workbook object and excel
instance are destroyed and then the loop goes to the next workbook,

I'm having an issue and I can't figure out how to look it up to get a
proper answer, nor can I find an answer in the books that I have, so I
figured I'd try here -- I have a spreadsheet that I am trying to link
to other spreadsheets.  In one column, I have data that tells me what