I have the codenames for various worksheets stored as strings in another
worksheet.  How can I assign each sheet to an object?
e.g.  If I have the string "myCodeName" which is the codename for one of the
worksheets, and want to assign it to a worksheet object

As figure shown below I want the sub total shown on right side of figure
column, to be automatically calculated by Excel formula or VBA macro.(e.g
when the empty cell appear in the figure column accordingly subtotal
calculated in right side of the figure column.

Iam looking for forms to Petition for Divorce, Custody and Support.

I wish to pass a worksheet codename to function.  How do I do this?
So far......this fails to pass the codename shAIF to the function
Sub Test
  MsgBox FindReport(shAIF, "New Report")

I know this is not right group to ask help but I will be thnkfull if
any one can point out the right place.
In my office we are using corporate LAN which bans internat email
sites.

Hi All, i have a report that i delete the old sheet and replace it with a new
one. What i would like to do is create a command button with VBA and place it
on the new sheet (ALL LC PARTS) and it must have a comment "BACK" on it the
code for this button would also have to go into ...

The following text (or variation of it) is always in Cell H7 on a sheet
called "SetUp"
Some parts of this string are static, and others are updated as required.
I want to find and replace the text (which in  this case is "FOODLIFE") with

How can I test to see if a particular workbook is open?
Thanks,
Art

I have one worksheet containing a list of all sales from all salespeople,
salesperson's name is in column B with other details in further columns.
Eg  Master sheet
Col B               Col C         Col D        Col E  

I am sure there is a very quick answer to my problem but it is outside
my limited knowledge of Excel Macro's.
I have a sheet that I import data to.  Data is imported into the range
starting in cell A4 and across to column AZ.  The number of rows

If I set up a query table on a worksheet and use an Access db or
another Excel file as the data source, is it possible to modify the
data from Excel itself? If so, by what methods?
Cheers,

Hi,
     I have been using following code :-
_Chart chart = chartobject.GetChart();
if(3 == m_numAxis)

The formula below works okay, but is a mixture of code which might cause some
problems for me down the road (and is probably not doing what I need it to do
very efficiently); I also ultimately need to setup something to copy the data
to the 'merge' worksheets which will be used ...

In Excel 2003 I am wanting to setup a formula where column C minus column B
with the answer in column D.
I wish to repeat this formula in an unknown number of rows where each column
will have a different value, and I also wish to hide the formula.

Can multiple selection available to copy to new Workbooks ?
Suppose I select A1..A4 , C1..C4 ... , Can able to copy Selected Range
to new Workbook ?
I can not find the coding about multiple selection for unnamed range.