Thread: Any way to add hex numbers?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Fan924 Fan924 is offline
external usenet poster
  
Posts: 238
Default Any way to add hex numbers?
Never mind. I found this in a Macro I did a few years ago and forgot.
It works. Sorry

ActiveCell.FormulaR1C1 = "=RIGHT(DEC2HEX(SUM(R[0]C[-4]:R[4097]C[-4])),
4)"
Reply With QuoteReply With Quote