Hello,

Was wondering if there is a built in command or more efficent way to
determine if values in a column range are the same.

The simplest, but maybe not the most efficient way i can think of is to do:

activesheet.Range("a1").Formula = "=Min('sheet1'!B1:B1000)"
activesheet.Range("a2").Formula = "=Max('sheet1'!B1:B1000)"
if activesheet.Range("a1").value = activesheet.Range("a2").value then
'values in column range are the same.
end if

Anyone think of a more efficient way of dong this? Does excel have some sort
of similar built in function?

Thanks!