Recalculate based result

lost1 · May 7th, 2002, 12:29 PM

I have a set of numbers that are radomly generated. There are seven steps in the list if numbers. The first set radomly generates a number. The second confirms validation. If the number is invalid, it returns "0". The third through seventh step aso confirm validation. If any of these steps show true (as being in valid) they return "0". Is there any way to recalculate that particular row when that row of numbers returns "0" .

Thank You
Larry Roudebush

Brian · May 7th, 2002, 11:09 PM

Using VBA you can recalculate only a range of cells (search help for "calculate") i don't think that there is a keyboard equivalent.

You could use a worksheet_change event to as a trigger to check the cells for "0" and then recalc that row until there are no zeros...

press F9 to calculate all worksheets in all open workbooks.

To calculate only the active worksheet, press SHIFT+F9.

CTRL-ALT-F9 forces every function to recalc.

W

Nimrod · May 7th, 2002, 11:12 PM

What makes the random number an invalid number ?
IE to long ? To short ? etc

lost1 · May 8th, 2002, 01:20 AM

What I have is an excell spreadsheet that generates a schedule for my associates at work. Each associate is given a number and the scheduler assigns that number to a job. If that associate has already done that job or cannot do that job, it assigns that job a 0. Then, if it finds that a job has a 0 assigned to it, it randomly picks a new number.

May 7th, 2002, 11:12 PM	#3
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	What makes the random number an invalid number ? IE to long ? To short ? etc __________________ <MARQUEE>...........Never be afraid to try something new. Remember, amateurs built the ark, professionals built the Titanic...............The easiest thing to find is fault, don't be easy !.. --Anonymous--...</marquee>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 7th, 2002, 12:29 PM	#1
lost1 New Member Join Date: May 2002 Posts: 2	I have a set of numbers that are radomly generated. There are seven steps in the list if numbers. The first set radomly generates a number. The second confirms validation. If the number is invalid, it returns "0". The third through seventh step aso confirm validation. If any of these steps show true (as being in valid) they return "0". Is there any way to recalculate that particular row when that row of numbers returns "0" . Thank You Larry Roudebush

May 7th, 2002, 11:09 PM	#2
Brian Board Regular Join Date: Apr 2002 Posts: 113	Using VBA you can recalculate only a range of cells (search help for "calculate") i don't think that there is a keyboard equivalent. You could use a worksheet_change event to as a trigger to check the cells for "0" and then recalc that row until there are no zeros... press F9 to calculate all worksheets in all open workbooks. To calculate only the active worksheet, press SHIFT+F9. CTRL-ALT-F9 forces every function to recalc. W

May 8th, 2002, 01:20 AM	#4
lost1 New Member Join Date: May 2002 Posts: 2	What I have is an excell spreadsheet that generates a schedule for my associates at work. Each associate is given a number and the scheduler assigns that number to a job. If that associate has already done that job or cannot do that job, it assigns that job a 0. Then, if it finds that a job has a 0 assigned to it, it randomly picks a new number.