ok, I understand offsetting rows and column, but what is ".Value + 273#"

Set cell = ActiveCell
T1 = cell.Offset(0, 0).Value + 273#

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. See VBA's help
for different kinds of data types.



widman wrote:

ok, I understand offsetting rows and column, but what is ".Value + 273#"

Set cell = ActiveCell
T1 = cell.Offset(0, 0).Value + 273#

--

Dave Peterson

"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

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