Select a cell at random based on multiple selection criteria across multiple sheets.

Hey all, new forum user here. I have bit of a problem I can't wrap my head around. I have to select a cell at random and delete its value, but the random cell I select has to meet some criteria:

1. It has to be in the Range C3: L12 (in a worksheet called 'WellPlacement'),
2. It has to be unpopulated (i.e. it can't already have a value > 0),
3. It has to be within a close proximity (+/- 3 cells) to an already selected cell (within the range C3: L12),
4. The equivalent cell in a separate worksheet (named 'ContaminantPlume') has to be populated. For example, if the selected cell in 'WellPlacement' is E5, then E5 in the Worksheet 'ContaminantPlume' must have a value > 0. If the cell E5 in ContaminantPlume = 0, then E5 in WellPlacement cannot be a candidate for the random cell selected by this function.

I've figured out how to incorporate the first three criteria using the following code:

Please Login or Register  to view this content.

It's the 4th criteria that I can't seem to work out. Any ideas?

Thank you for your time! -Scott.

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)