Can anyone help.
I am trying to do a calculation in a cell based on dates.
A1 data is the person's birthdate in dd/mm/yyyy format.
B1 data is a start date

I'm having problems with concatenating string variables together.
This code works:
Dim text As String
Dim front As String

I've got a strange problem with Excel 2000 (Office 2000 sp2)
Even a single worksheet, with little information ( 50 rows by 10 columns )
creates a .xls file that is over 2 megabytes in size !
There are no macros present and the file is not infected by any viruses.

I am a newbee in writting Macros. I wrote one and now after that whenever I
start Excel, a file opens with file name: "PERSONAL".
I went to following folder: C:\Documents and Settings\TOSHIBA\Application
Data\Microsoft\Excel\XLSTART

I'm using excel to create a control card that I will
duplicate on the worksheet 54 times.
I want to enter a team name on each of the 54 cards.
Is there a way to automate this if I have the 54 names in

I'm not sure how this happened, but within one of my spreadsheets
everything is dead...  I was thinking some kind of arbitrary
protection got invoked, but I can't find it.  Basically I have two
formulae, one that takes the first name from "Last, First" and puts it

I was posed a question the other day of which the answer I am not quite
sure.  Is there a way to take information from an Adobe PDF file and export
it to an Excel spreadsheet?  If you have any idea of how it can be done, I
would appreciate the reply.

I want to track changes to cells because a formula calculates a ne
value, not because i changed directly the value of a cell.
the excel help indicate the following:
Cells that change because a formula calculates a new value---> To fin

I am trying to automate an invoice where I can lookup a data table using
a customer code, and then drop each item the customer purchases into
the inoice.
I can use the vlookup function to return a single value, which is the

I have a sheet where I calculate return on investment for some equipment. Is
there a function that converts 1/10th of a month to 1/30th so that my figure
is displayed as months,days?
Cheers, Thorbjorn

I would like to conditionally format a range of cells so that the cells that equal the MIN() or the
MAX() value are bolded.  Is it possible to use a function such as:
=MIN(C27:E27)
as a condition to bold the cell's values?

While writing in Excel through Code I have also merged the cells.
       _objRange = _objWorkSheet.Range(_objWorkSheet.Cells(_intCurrentRow,
17), _objWorkSheet.Cells(_intCurrentRow, 18))
       _objRange.Merge()

How can I enter a conditional formula so the cell color changes based on odd
or even numbers?
Ex: even numbers - cell color is white, odd numbers - cell colors are grey

I work for a company that issues its customers with prices usin
excel... we have thousands of prices.. is there any way  of covertin
all the indvidual prices and descriptions into a simple program or fil
so that customers can do a very quick search for a price!!  The progra

Is there any way that you can copy just the names of a range of named
cells from one workbook to a totally different file?
For instance - I name a row of cells something (like Jan-AcctsRec,
Feb-AcctsRec, etc.) on one spreadsheet in a file.  Well, I want to copy