i currently have a formula in a cell that makes a large random number
the random number is use as a order number and is put with other data in a list of orders.
=RAND()*(100000-12000000)+12000000
how to i make an if statement inside a macro which will search down a set of rows to see if there is a duplicate number in order to made sure the same number is not used twice
thanks for any help
Hi,
I put this together a bit ago that might point you in the right direction.
Hope it helps,
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks