I am running Excel 2007 with Office but I want to have the feel of Excel
2003.  Is this possible?

When coding in VB, why are the built in applications, particularly
Cells.Find(), faster than loops?

How do I  truncate a number in scientific notation without rounding the last
number?
example:
    D22: 7.20117 E12  and I want 7.2011(0) E12

I'm trying to set a relative reference as an "object" in VBA.
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
I want this to be my "Object"
Should I Say;

I want to sort from cell a1 to a10 in a column.  However, I can only able to
sort from cell a2-a10 eventhough I selected cell a1-a10 and clicked sort.
What is going on?

how do I get data that auto updates totals and percentages to do so on
another sheet ( sheet1 to sheet2), in other words I've made a
spreadsheet that is a daily sheet that auto updates to a weekly total
on sheet 1, I want to make another sheet to take weekly into

I'm new to this newsgroup and newsgroups in general and I hope its ok to add
snapshots to posts....
I created a sheet a while back part of which showed a monthly snapshot of
when staff were working.  The issue I had was that staff worked on a

Cell validation is not working even when irrelevant data is copied and pasted
into cell with validation.
Is there a fix for this...
Any response is highly appreciated...

i get reports from (idx) a program that are delimited files.  the
columns are all fine but 1 and i can't figure it out.  its supposed to
be money and comes across as 11500.  in the original program (idx) it
would look like 115.00 and that is how i want it to look in excel.  i

how to set the date to appear Automaticaly, when i open excel

I would like to be able to copy a formaula into cells, or better say, a
column of a worksheet which has over 50,000 rows. I can do it by dragging the
cell over the others, but is there a way to do this without having to go
through this dragging thing?

this macro doesn't work...it should delete any how that doesn't have
"NCG" in column 13, but doesn't work
  Application.ScreenUpdating = False
  Application.Calculation = xlCalculationManual

How do i add more than one item to the body of a outlook mail using vba.
I am using named range to select the items.
i want to add Text, the leave two lines HTMLBody then leave two lines and
add another HTMLBody and leace two lines and add Text

I am trying to do a simple Pro Rata calculation.  $185 is paid for a
year of service.  The service is cancelled during the year and money
is owed back to the customer.  I am getting an error on what should be
a simple calculation.

Help, I need a formula to increase the surcharge on fuel for my company and I
know nothing about this task. for example :
FUEL SURCHARGE INFO.
2.870 - 2.935  13% added to fuel charge and calculated automatically when