PDA

View Full Version : Solved: Cycle through validation list and spit out value of a specified cell



sassora
02-10-2010, 06:00 AM
Hi,

I have put together tables which are generated based on the options selected in a drop down menu. There are three validation drop down lists and a cell that checks says whether calculations have been done correctly. I would like to be able to cycle through each possibility and at each point return the value of J3 into the immediate window. The task is too large to do manually.

I hope you can help.

sassora

Bob Phillips
02-10-2010, 06:09 AM
How is the DV populted, a range or a static list?

sassora
02-10-2010, 06:21 AM
How is the DV populted, a range or a static list?

It's a static list