You can ignore or return blank cells using the IsEmpty function or
by determining the cell length (0 if blank) using the Len function.
Also, checking cells with the TypeName function ensures that you are
doing a comparison on the same type of data...
Range("C1") = ("frog" - 1234) doesn't produce much useful info.
--
Jim Cone
Portland, Oregon USA
XX (remove xxx)
(trial version of XL Companion available upon request -
compares worksheets, selections, rows) - does other nice stuff too.



"Jimbob B"
wrote in message
I am trying to create a macro that will compare the data in Cells A
through D on two different sheets. Then post the results on a third
page.
The problem I am having is that there will be blanks on both reports
that can not be deleted. For instance on sheet 1 column A3 and A4 maybe
blank but they are assinged to the DATA in B3 and B4. But sheet 2 has
values for this.
I have tried the VLOOP function and that does not seem to be working the
way I need it too.
I have tried many different ways and seem to be getting no where. I
have been working on this project for about a year and I have scrapped
aleast 20 different concepts.
I am running out of paitence. Any Help would be greatly appreciated.