View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jamieuk jamieuk is offline
external usenet poster
 
Posts: 8
Default Testing for contiguous cells

For a game, I need to determine whether non-blank cells in range
A1:J10 are orthogonally contiguous. If I had values in cells A1, A2,
A3, B3 and C3 then the result would be true. However, remove the value
from cell A3 and the result is now false. Any ideas how to do this
test?