Hi Niek,

I got an email today saying I had exceeded my monthly bandwidth, so my host
has disabled it. It must be getting popular <g. I'll have to check out how
much I need to pay to increase it.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Niek Otten" wrote in message
...
Sorry to bother this way Bob, but your site seems to be offline

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Bob Phillips" wrote in message
...
| One of the big problems with using that syntax.
|
| Why don't you write a UDF, you can add error checking easily then (when
| there aren't 3 for instance)?
|
| --
| ---
| HTH
|
| Bob
|
|
| (there's no email, no snail mail, but somewhere should be gmail in my
addy)
|
|
|
| "Werner Rohrmoser" wrote in message
| ...
| Hi,
|
| I use a mane with a relative reference to sum 3 cells to the left or
| in another case
| the 3rd, 6th, 9th and 12th cell to the left.
| The syntax for the name is "!A1:A3" when my pointer is in A4, formula
| is "=SUM(Name). I wrote it without the sheetname, because I'd like to
| use it on every sheet I have in the book.
| Now, when I change values in the precedent cells nothing happens until
| I force a complete recalculation,
| it doesn't calculate automatically, also F9 doesn't force the formula
| to calculate.
| Any ideas or workarrounds, especially for "3rd, 6th, 9th and 12th"
| case.
|
| Excel XP SP3
| Win XP SP1
|
|
| Regards
| Werner
|
|