I have a list of addresses that I should like to convert to a table, they
each contain 4 fields, as follows:
John Doe
123 Street

after upgrade to off2003, for some users after opening an xl-sheet, the sheet
is not automatically recalculated (for other users it does!)
we have removed users from active directory and local pc: first problem
seemed to be solved, but it returned!

I am trying to select a sheet using
xlBook.Sheets("AP-STT(U)").Select
as you can see the sheet name has parentheses in it,   so excel gives me a
"Subscript out of range" error.

something wrong
I think

Is there a way to format a cell as a condition of an other?
Expl.   Format Cell  A1  if  Cell A2 meets certain criteria.

I'm learning macros at the moment and thought I'd venture to write one which
I needed myself but I could do with some help, since I spent hours today
trying everything that occured to me and searching the internet when I
should be studying since I've an exam on macros tomorrow.

I often use excel as a fancy calculator.   But often I forget to start the
calculator with the = sign.    So if I want to add 44 + 66,  I forget to
type in an = sign first, an it gives me an error message.    Is there a
setting to turn that off, so I can type in 44 + 66 and it gives ...

I work in a school and we have an excel spread sheet with many ip addresses
that have been input into it incorectly.  To make it work i need to first
find the addresses without the zeros and add them where needed.  For
example; the need to look like this -172.22.033.010 not like ...

I've got a formula in a column, but in certain circumstances I may  
overwrite this formula with a number (too rare a special case to bother  
covering)
What I'd like though is to use Conditional Formatting to alter cell to  

I would like to find an excel sheet that has pipe sizes in a chart, and
possibly weights.    Also a chart for forgings like flanges, weld necks
etc... in excel spread sheet.    Thanks in advance.

I put in a wrong formula and then I went to the function help and it said to
open a blank worksheet, Select the example in the Help topic. I can't find
the example in the help topic. Do I open a blank worksheet and then press
CTRL +C to opent the examples? I was in the ATAN ...

Today, whilst sorting a worksheet Excel behaved in a way I didn't expect.
Column F, rows 1 to 200, contained concatenations of the previous five
columns i.e
=A1&B1&C1&D1&E1

Howdy,
I've got a list of 250 some odd abbreviations and full codes for excel
data. I want to run a macro that will search for A1, then replace it
with the value in B1, then A2 with B2, and so forth until the end of

I'm sorry in advanced if this has been covered before, or has an obviou
answer.
A client of mine has been providing me with contact data through Exce
2003 pivot table.  The address "cell" contains address 1, address 2

i build some macro in excel based on access,
at the start i'm doing manual calculate in the code so it will not
desturn the proccessing
but in the end of my automation i'm bringing back the