View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David David is offline
external usenet poster
 
Posts: 1,560
Default Unexplained change in variable

Hi Group,

I have something very strange happening, that I can not explain. I have 2
variables:

TotalValue = ActiveCell.Offset(16, 0).Value
(Gets set to 102,000, which is a correct value.)
TargetTotal = ActiveCell.Offset(64, 0).Value
(Gets set to 35000, which is a correct value, BUT TotalValue becomes 35,000)

I am not sure what I am missing in this process. Can anyone tell me why this
would happened.

Thanks,
--
David