Newbie needs help to perform a checksum based on XOR

[Nullplan]

Hi, being a total newbie to excel stuff I hope I will understand your replies to my problem.

However, I'd like to calculate a checksum for a row of HEX-bytes based on XOR. Result should be in hex aswell !

Example:

aa XOR bb XOR cc XOR dd ...

Windows' own calculator will do the trick but with a growing number of bytes to 'xor', I tend to produce typos. Not to mention how boring that is... *g*

BEST would be something like a function: XOR (A1:A200)

 

[Reload2000]

Hi Guys, I'm another newbie with exactly the same requirement. I have tried both the above and am getting the same error as sydinstaller when I try Damon's method and when I use Greg's revised method all I get is the bottom number in the column of hex values.

I thought I had the perfect solution to my problem but am obviously missing something. I have never used VBE before so if someone could explain what to do I'd really appreciate it.

Thanks in advance

Ed

There is a typo in the code, otherwise its just perfect. The code should be as follows - part of ChkSumXOR is missing _2010 in this line:


ChkSumXOR_2010 = wf.Dec2Hex(wf.Hex2Dec(ChkSumXOR_2010) Xor wf.Hex2Dec(Cell))