View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default hexadecimal mathematics

Just subtract the numbers

a = &H22
b = &H33
c = b - a
MsgBox ("Answer: " & c & ", Hex Answer: " & Hex(c))

The answer above is 17 decimal, which is &H11. You need to format the 17 as
a Hex Number using the Hex function

"vikas" wrote:

how to substract two hexadecimal numbers