View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default what does this mean?

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