Is it possible to show a form, task-switch to another application, then
somehow put focus on the form so that it shows but with the other
application in the background, rather than Excel in the background? The
form I am using is generated by a macro assigned to a custom button.

Thanks to JW I was able to implement this procedure in increments but unable
to to make it work in one fluid motion.
I would like my users to select a closed file, then on an active sheet
automatically import cell values from the closed sheet to cells on the

I have recorded a few macros in Excel but I have very little expirence with
Visual Basic.  I have written the following macro and it works great except
I would like to automatically run when the sum of "af1" gets below 10.
Sub Macro1()

I have a macro that compares two sets of data. Sometimes there isn't data and
so there is a #DIV/0! symbol. How do i go through the cells and delete all of
these?
Thanks in advance

I understand that Excel 12/Office 2007 will be XML based...my terminology
may be technically incorrect here, but I think you know what I mean...so in
anticipation of this:
1) Does anyone know if Excel 12 will support ADO?

I'm having trouble with a function that takes a range as a parameter.
I'm using the function on one sheet, but passing in a range that is on
another sheet called "Data", so something like Foo(Data!A1:A10).  The
formula seems to ignore the sheet reference and use A1:A10 on the page

How can you protect certain cells on a worksheet so that users can't
alter there contents but can have access to others to enter required
information. I'm sure this is simple but have never needed to do till
now.

Should I be concerned that NORMDIST(4.92, 4.94, 0.08, FALSE) returns
4.83?  This should be the noncumulative (density, mass) function
associated with the normal distribution.  Surely it cannot exceed 1
because the entire area under the curve cannot exceed 1, by definition

I have a long list with no spaces, all in one column.  I am trying to
add 7 blank lines in between each row.  What is the easiest way to
achieve this?
Thanks in advance

i want to write an error statement but it's not working for me.
The code below works when the cell value equals #n/a BUT it screws up
my macro when the the cell value doesn't equal #n/a. I'm getting an
error 13...

I have a macro that prompts the user to open a file. Currently it is a .csv
file but i want it to be able to open .csv or .xls. This is my code:
fileToOpen = Application.GetOpenFilename("Excel Files (*.csv), *.csv")
Is there a way i can add an OR or AND somehow or make it be able ...

I was wondering if there is a way to read from different excell workbooks
that are closed. I am trying to read data from different workbooks do some
calculations and then store the values in my current workbook that is open.
If I open all the workbooks, I run out of memory. I ...

I'm tring to write a macro that loops through a folder on my computer and
deletes all the worksheets that have only 1 sheet in the workbook.  I would
also like to have the procedure delete any non .xls files too if possible.  
Does anyone have any ideas?  Is this possible?

I have this simple 3 subs vba code. It runs 8 times and each solution
has 24 values that is put in one column of 24 raws. So, the 1st
solution found gets written at N2 to N25....and so on.
The problem I have is this: The 1st solution that gets written from

Is there a way to do the following?
IF count = odd number Then
END
Thanks,