I have a three part question.
First, I want to be able to assign a value in a cell, on
only one of three worksheets, to a variable.
Second, I want to be able to compare that value using a
CASE statement.
Finally, I want to be able to associate this macro to a
command button that will run it.
Thanks in advance,
Al