Trying to write a formula to go to first worksheet look if there are
any numbers or words and if not go to next worksheet and do the same.
If both are empty, then the cell should be left blank.  If one or
other has info then that should be result, if both have info then put

Thanks in advance to anyone that can help me here.
I have a workbook that will have a varying amount of sheets with
different names.  The range in # of sheets will be 2-10.  What I need
to do is use the formula =MIN(Sheet1:Sheet2!A1) where A1 is the cell

If we type a built in formula it automatically changes to upper case.
How we can make a custom function to automatically change to upper
case?
Thanks,

Hello Experts,
I am brand new to VBA, and am having a few problems writing a macro.
I would like to have the macro search through my data and find the
PT1, PT2, and 2.  Whenever one of these is found, I'd like some data

I thought some may be interested in the results of a speed test I ran to
verify some processing theories.
Machine:
HP

I am writing a text file with numbers which I would like in E16.9 fortran
format, example:
-4.543785477E+01
1.675241709E+00

I noticed that if I create a List object and center align the fields, fill
some data in, delete all the list rows, and then fill the data in again, the
second row in the list object will would change to general while the rows
above and below it are still fine (centered).  This is ...

Hello, I have the following code in my workbook and it used to work fine
(from what I remember from working on it last week), but now I am getting an
error message that says "Unable to get the FindNext property of the Range
class" - I have a feeling it has something to do with ...

Wondering if anybody can provide an answer to this:
Some time ago, it appears that the Microsoft mouse using intellipoint
drivers "broke". That is, the programmers developing the Office VBA
programming enviornment apparently didn't bother to read the MS spec for the

I have a multipage on a userform.
On the multipage i have an number of textboxes (>20).
The contect of the textbox is looked up in a databasesheet ("datadga")
through this code;

I have data with multiple columns.  I want to count all items in column A =
"X" and with column B > 250.   I know how to do either condition but I need
to join the two.  Any help would be appreciated.  Thanks!

userform1.show
After the following code ,and then I want to be focused with mouse
pointer to the specific button(for example, commandbutton1)
automatically.

I have a dll writen in c# which is used to read from a database. I'd
like to be able communicate with this dll from within my vba code.
What I'm unsure about though is where I should locate the dll since
this excel file will be used by multiple users on multiple machines.

I want to have a single cell in my MS Excel 2003 spreadsheet that
combines both plain text with the value from a Named cell.
It would be something like:
The text I am looking for is (=VS1).

I want to get  A list of the ranges that i have named in a workbook that I
did not create. I named 2 ranges
But when I run the following code, I get the 2 ranges I named plus
additional names that I did not create and that don't appear in the define