Random numbers but 3 numbers in sequence not allowed.

Originally Posted by NewGen

Patel45 and tom.hagan, thank you for your reply. It worked for patel45. Tom.hagan I am afraid I got a run time error "438" object doesn't support this property or method. Btw I am using Excel 2003.
Thank you Cutter for your gentle reminder.

Sorry, I used an Excel 2010 function, that's why you get the runtime error

Tom

Patel45, When I ran the code I managed to get random numbers without 3 consecutive numbers in sequence. It didn't quite appear right as some numbers may be in pairs such as 5-6 or 12-13 etc. I allowed pairs but not 3 or more consecutive numbers. I tried modifying your codes using And,Cells including changing Number > 2 but without success. Thank you for your patience.