Hello this is going to sound like a lame question but I was wondering is
there is a way to get the row from a formula. For example I am using the
large formula to find the second largest value in a range, I would like to be
able to find the row of the value that the large formula ...

Hi All.....
I have a little Query macro that works just fine on my computer, but
unfortunately has the path to the source file hard coded inside, and
therefore won't work on anothr computer.  I would like the Query to always

Having Sheet1 containing number of people per Resource and Week,
Sheet2 Range E2:I10 contains number of hours per Resource and week
based on interiorcolor and forecolor of each Cell in Sheet1 Range
E2:I10

RM Smissaert kindly replied to my recent Q of how to disable screen
updating in a TreeView:
Private Declare Function SendMessage Lib "user32" Alias _
       "SendMessageA" (ByVal HWND As Long, ByVal wMsg _

One can easily find the limitations of a particular version of Excel in the
help of the product. But what if one wants to compare the limits that have
evolved between Excel 2000, 2002, 2003 and 2007?
Thanks

I have a few thousand rows Of data, each row has 1-7 outputs in the adjacent
columns. There are 27 different types of outputs. Lets just say A- Z, the
maximum amount of outputs for any row is 7. Some only have A, some have, A,
B and C and so forth. Each output is in its own column.

I have an array as follows:
Dim data(1 To 6, 1 To 6) As String
Then I give values to my array:
data(1,1) = "Value 1"

I am retrieving data from AS/400 database to a worksheet
using QueryTable and I have the following problem.
My code is as follows:
'*********************************************

I have a macro adding a row. I need to copy this to the row above it. My
problem is I don't know how to refer to the row above it when it will change
row number all the time as rows will be added constantly.How would I do this?

I am trying to define the last row of column A as a constant, which I am able
to do.  Then I want to apply that constant to the MAX and MIN functions, as
so:
   Dim LastRow As Long

contents of the text file
Name =
*"dev"/"null"
CodeVersion

I'm having trouble displaying the greater of 2 values in a cell.  I can
program it to display the cell number, but I need it to display the value of
the cell in another cell.

How do i call and open a txt file (Notepade) using macro?
Tks in advance.

Thanks for taking the time to read my quetion.
I am trying to determine how many rows and columns are in my merged cell.
I can't seem to figure out how to do that.
I'm working with

Excel XP & 2003
I have a lot of VBA in a file that is being used by a dozen or so offices
throughout the state, one computer per office.
One, and only one, computer is getting a consistent error on the statement: