View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Excelenator[_16_] Excelenator[_16_] is offline
external usenet poster
 
Posts: 1
Default units = ActiveCell.Value overflow


Try changing the variable type to Double. Int is not going to accept
your value if it has decimals.


--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=566328