I wrote one formaula for a cell say (A3) which calculates the sum of
cells A1 and A2
When i am going to access the value of cell A3 it is giving the value
as       =SUM(A1:A2) but i want the summation value.

I have a column which contains text like A, A*,AI,AT,D, etc.
I would like to replace only the A* value by A-* using vba (because excel
consider the A* as any text beginning by A). My formula below doesn't work.
Any idea?

I have a master sheet that will have some additional sheets
modified at various times.  I want to have all my code saved in the
master sheet and applied to the other sheets from there.  For example:
I want to have the following code saved in the "master" sheet but

Alright, I know this is a very 'newbie' question, but it's beating my
brain-pan, and I'm coming up on a deadline.
 I have a form that collects the data and posts to spreadsheet.  Although
the col is formatted as currency with specific format (###0.00), when the

I was wondering if there is a way for the ability to press a letter  and for
it to call a macro on a worksheet.
Jason

I have a simple test sub :
sub gsgs()
   dim fred
   fred = Range("F10").value

I have recorded a macro to print my worksheets to a PDF buts its forcing me
to create multiple PDF's. There are 6 worksheets I am saving and the output
is prompting / saving 3 PDF files. The first has 1 worksheet, the second has
4 worksheets, and the last has 1.

xl2003, win xp
Each day I get a list of races that I need to sort into a single column
starting with the earliest race. The number of races varies from day to day
So the web query looks like

Is it possible, using VBA, to get the FORMULA instead of the VALUE of a
cell using a VLOOKUP ?
When I do this in VBA:
   result = Application.VLookup(strName, _

I received an Excel spreadsheet from an outside vendor that has very
cool functionality.
It has what I call a "floating listbox" that moves from cell to cell as
I select a different

In my Visual FoxPro Code, I create an excel spreadsheet but do not save it.
Once in Excel, my client would always want to save the spreadsheet in a
certain folder. I would like to set the folder for the client. Unfortunately,
the following code only seems to work the second time. ...

Question is for either WorkBook Open or WorkBook Close.
Scenario # 1:
Code in WorkBook Open.
Scenario # 2:

Hi ive got the following code running manually on a spreadsheet. But I need
it to run automatically only when the macro is in a particular folder. Need
any suggestions or ways to improve my code..thank you in advance!!..
Sub main()

I have the following:
If current = temp then
End if
My problem is the following:

I have a colum within a table that indicates one of three things:
1. the date an interview took place as dd/mm/yy/hh:mm
2.string- 'declined on phone'
3. string-'declined at interview'.