Right, I currently have a main summary sheet on my second sheet in a
workbook, on this sheet I have a few buttons that will run a number of
different optimizers. One of these optimizers happens to be solver so
when the button is clicked solver is launched and will then run an

My spreadsheet has a button menu page and the previous author created the
buttons by using shapes.  I am recreating and using forms controls and
inserting actual buttons.  There is one of his 'buttons' that is hyperlinked
to a third party program. The hyperlink is formatted

If the files I am trying to combine have blank cells within the data is there
a way to skip the blank cells?

I am having problems with Excel 2007 that I did not encounter in
previous versions of Excel.
Symptoms:
Using statistical functions, such as COUNTIF and SLOPE, the result is

I need to do a Vlookup using a key column to grab about 10 columns
from the lookup table (1000 rows). Using the VLOOKUP function turned
out to be very inefficient (10000 cells of VLOOKUP). I was wondering
if this could be accomplished more efffectively using some variation

I am working on a project where I need to do some Excel programming,
while I have programming experience I have never done it in Excel
before and I have some questions that I hope you could help me with.
What is the best way to save data (the value of variables) in the

I - unfortunately - use Excel 2007. I wrote a macro for the following
task:
- a folder contains a number of files, each with 3 tabs, "Source
Data", "Details" and "Summary". These files are reports, all in the

I am trying to figure out a formula that will spread out a certain
number (costs) among a predefined number of periods (months) into an S-
curve shape.
Essentially,  I have 3 inputs.

I wish to programmatically set the conditional formatting of a range of
cells to highlight those cells that are locked.
I can readily do this 'manually' by highlighting a range of cells (say
A1:A7) and then entering a conditional format formula of

I have a sheet in which 3 columns are for data feeding and i need that
if any body feed any item in non blank cells then it will be locked
and he couldn't alter if he fed the data once.
await for early and positive response.

I'm trying to separate a tons of data into individual fields with its
own column for each title. The data in one individual cell (A1) looks
like this:
TI.A.38.01. *Name: 1: ABDUL BAQI 2: na 3: na 4: na Title: a) Maulavi

I want to create a userform that can string a selected range of cells to a
textbox.  I can do it on predifend cells, but I want it to be flexible so
that you can highlight the cells and then click a button that will string it.
Can anybody help me with a link to a page that ...

I got two ranges/areas like:
rng1 = A1, A2:A4, A10:A100, A102
rng2 = A2:A3,A15;A102:A200
I need to get the ranges who differ:

I am trying to get a string from a cell value so that I can use indirect to
reference tabs. The tab names are in a column in tab "User Guide". I used the
code:
   Dim tabName(0 To numWS - 1) As String

my question is about mail merge,  data is in excel and I am merging it
to word.
How can I group rows in excel so that when merging to word the group
of row in excel can be merged as a group on the same page in word.