Compare three worksheets

[MusicMan]

Hi,

I'm trying to compare three worksheets and output data to one of them, however the following code it not quite doing what I've expected. Please see if the following can to modified to assist with my problem.

Please Login or Register  to view this content.

Thank you in advance for your assistance.

[Kaper]

to start:
1) cel3 is newer assigned, so (being Range type) it is permanently Nothing
2) unlike in mathemetics, in VBA you cannot do

Please Login or Register  to view this content.

to check if three values are all equal. VBA will test a=b and result of this part will be boolean (either TRUE or FALSE) then this TRUE/FALSE will be compared with C. So you have to test

Please Login or Register  to view this content.

instead (of course from maths we remember that a=b and b=c implies a=c)

may be 3) Have you tried to check what is assigned to cel2 after

Please Login or Register  to view this content.

?
As there is no test workbook I have not tested, but somehow I'm not sure what result will be returned here. Anyway - correct two above points first

[MusicMan]

Thanks Kaper I will provide a workbook as soon as I can.