Except in some weird cases to avoid overflow errors.

Bob Phillips wrote:

"Dave Peterson" wrote in message
...
It adds 273 to the value in the activecell and stores it into a variable
named
T1.

.offset(0,0) doesn't help. the code is still pointing to Cell.

with 273#, the octothorpe (#) means to treat 273 as a double.

Which is pointless, 273 is 273 whether declared as double or long

--

Dave Peterson