Sadly, I've just learned that one cannot postion a msgbox (non-Center) and
maybe a msgbox is not what I need (in the 3rd instance only - in code below).
I put the 3rd msgbox into my code so that I could **pause** the code that a
user could review the screen data and then ...

When StepThru=true how excatly  i get the cells which added as the
left side of the constraints in the VBA function
I can get them directly from the sheet(i hold a collection of cells)
But is there away to get them from the solver?

Hello, i need to loop down a sheet and collect all e-mail addresses to
send an e-mail to the relevant people, is this possible in Excel ??
Les Stout

I am querying an external database and get a syntax error message that looks
like:
SELECT CMT REGISTER_TRANSACTION.Bank_Account,
CMT_REGISTER_TRANSACTION.Check<<???>>, etc, etc.

Hope someone can help, I am trying to pull data into Excel from SQL Server
2003 and  my script keeps failing, I think it might have something to do with
the way that I am construting my access string and specificaly the database
part as I am not sure if it needs to be surrounded ...

I am using the Macro shown below to search of certain items then
Highlight tham in Yellow.
When I run the macro it prompts me for the data I am searching for
them works perfectly.

I'm using the Worksheet_Change event procedure to call a macro when a certain
cell in the worksheet changes.  It seems to work okay, but if I have another
Workbook open, the macro tries to run in that Workbook also.  How do I keep
the macro from trying to run in other workbooks ...

I am using the BeforeSave event to replace the normal save action with one
that determines changed data and writes it to a database. The basic structure
is as follows:
 Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

Quick Question, Hope someone can please help...I need to use a Command
Button.  Users would click the button to insert a photo, from which
they choose from an insert dialog window, onto the sheet. The photo
would be placed at cell B4 automatically.  Then, to insert a second

I am creating a spreadsheet that calculates a person's time on the
job.
It looks like this
Inclusive Dates (Begin)    Inclusive Dates (End)        Totals

Hi NG!
Is there a way of capturing the cell address of an argument in a UDF in
stead of the value of the argument.
I have a UDF definition like

I have the following:
Option Explicit
Sub EnterData()
   Dim MyString As String

I have been writing a macro to process/reformat multiple data streams into a
single table for analysis.  Analysis is driven by pivot table and associated
pivot chart.  What I would like to do is to generate several chart views in
sequence, grabbing a copy or picture of each chart ...

Here's a macro that ALMOST works perfectly:
Sub TryNew()
Dim myCount As Integer
Dim myCell As Range

Hello, I'm an absolute beginner and have 2 things I would like to do on a
worksheet:
1.  Insert page break when certain text is found
2.  Merge text in 2 rows into the upper row, then delete the lower row (i.e.