B BIGTONE559 Active Member Joined Apr 20, 2011 Messages 336 May 31, 2012 #1 Greetings, I need help with methods of testing whether a range of data has the same value. . .(Boolean) e.g. Range("A1:A10").value=Variable I would like to test if the values in A1:A10 are the same. Please Help!