View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Wouter HM Wouter HM is offline
external usenet poster
 
Posts: 99
Default 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