Have a look in VBA help for Find,then findnext

--
Don Guillett
SalesAid Software

"Dan Chupinsky" wrote in message
. ..
Can someone suggest visual basic code for a macro to check for the
occurance
of a single digit (1-9) in a range such as A1:C3. Each cell in the range
must contain a digit once, ie. no repeats, and no blanks.

Dan