I need a formula that returns the cell location of the first instance
of a text string that I specify in a column listing.  I also need a
formula that returns the cell location of the last instance of a text
string I specify in a column.  For example lets say the text I want to

http://www.ozgrid.com/charts/dashboard-reports-color.htm
Before I give-up and shell out the bucks for this utility,
can any experts take a guess as to HOW exactly
these mini-charts are being done in Excel with VBA ?

Hi, is there some macro command in Excel VB with is triggered when a
given worksheet is opened?   If so what's the syntax?  Many thanks in
advance.

I'm really new at this VBA code thing and have found almost everything
I need here from this group just don't understand some of the complex
things:   Let me explain my problem
I have a userform built in VBA that has the following

My formula reads: =SUM(B6+B22+B42+B57)
The Result reads: "0" because there are no values in Cells B6, B22, B42 and
B57 yet.
How can I write the formula so the cell shows no value if it equals zero?

Dear Group,
Is there an example somewhere that shows how from an Excel addin to do
a "check for updates" by using the internet to contact my web site?
Thanks,

This is a log trendline formula from Excel semilog graphing.
y = 0.8065Ln(x) + 3.4412
can anyone tell me how the " 0.8065Ln(x) " part of this formula works?
I know y and i am solving for "x"

Hi, can someone please give me the syntax for Excel VB statement to
open a worksheet, which is named in "INDEX(dir, k)".  In my XLM
program the statement is simply "=OPEN(dir,k)", but I can't seem to
figure out how to write it in VB.  Many thanks in advance.

I am having trouble retaining blank rows in a worksheet upon sorting,
I have the sort code as follows:
Sub SortJS()
WS.Activate

We are using a complex macro to handle importing into a retail item
database. When the program is run, three forms exist. A fourth form is
created through VBA using the following code while the program is
running:

In VBA, the Worksheets collection starts at Item 1.
The Controls collection starts at Item 0  (as do most collections).
Is there a "rule of thumb" for one to recall which collections start at
1 and which start at 0 ?

I have about 16 sheets of various calculations. In some sheets i have
links from the remaining sheets which sort of sums up my reports for
the day to the company.  I did face lots of problems like, i cant copy
and paste becos cells are not identical or merged cells problems etc.

Trying to create an aid for my micro economics work for Price Elasticities.  
I need to create a conditional statement in absolute value for the following;
For the cell b14 (Price Elasticity Demand)
B14=0,"Perfectly inelastic Demand"

I am calculating simple monthly returns on a series of daily asset prices
for a number of years worth of data. The problem is I am not sure how to
indentify the end of a month, and the start of the next in a column of
05/01/2006 format sequential dates. I could just add another ...

I have this situation:
1 excel sheet with sets of ten charts, with new one all month.
I need to make ppt and doc with this charts, how do I can automating this
copy?