I'm using a VBA macro to repeatedly pull data from a MySQL database
using an ODBC connector.   This is the main subroutine with the query
(note I've removed various things from the macro such as server,
username, password and the exact query which aren't important)

Is there any way that the code below can be condensed or shortened
please
It cycles through six number combinations and counts the total of ALL
the digits in each combination. So, combination 10,11,12,13,14,15 will

urgent to know the furmula of R-squared calculation for polynomial regression.

The following code works but self interrupts and does not close and
consequently the worksheet freezes and is only released by pressing the Esc
key. Any suggestions?
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

I am trying in setup a excel sheet where someone entered someone
* workday start time
* Time they arrive on Site
* TIme they leave site

I'd like the user to either select the range of cell with email addresses or
type it OR be able to type them in directly.  I can only think of one either
declare a range or string.  for example, when declaring a range my code looks
like following:

I just need to set the value of a variable to the "A1" address of the
active cell. I feel like I've tried everything, but shouldn't this
work....
Dim rng as Range

I want to make an if function to look for merged cells, and then add the
contents of another cell related to the merged cells.
I.e.,
if( c2:c_n is merged)

I've created an Invoice in Excel and I'd like my tab or enter stops to be as
follows:
Start on H7
then go to H8

Hi All.......
I can step through the cells in a column ok, but need help now in stepping
through all the cells in a selected RANGE, (say C3:e7), and perform a task
against each cell.

how can i set it up so that i can have the program write out the combinations
between two numbers so that there are never the same number twice
and then add a third number to the equation
i need this for league teams

Hi,
I wrote a macro using IE application. But I can't move on anymore.
A dynamic table is display on the web screen and the source code doesn't
give me any information about the form and fields name. Therefore, the only

IO hope I can explain this, I have a userform that will open on a button
click from a worksheet.  First thing I am doing is testing the file name to
ensure the user won't overwrite the master file.
I can do that easily enough, the trouble I have is if the condition is true

Is there a way to preview your posts in Google or are there tags
you're supposed to use with code?
Thanks!
Cliff Edwards

How do I modify the current VBA script listed below to automatically
writeover the MATERIAL_ORDERS.xls file each time without prompting do you
have to replace this file.
Thanks so much for the help.