Syntax got me again
Hi DA,
Your first line of code only creates a variable with a strangs long
name.
At this point it has no value!
In yuor secod lie of code you are testing is the value equals "No".
Which it does not.
So the Else part of your code is executed.
You should asign a value to this variable toget the If part executed
Maybe something like:
ModelsAlreadyBuiltYesNoIndicator = Range("AH1").Value
HTH,
Wouter
|