View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default compare 2 mem variables against a string value

Hi,

The correct syntax is

If Mdl = "ZDX" Or Mdl2 = "ZDX" Then

Mike

"Ron5440" wrote:

Hey,
Can anyone help here...

If Mdl = "ZDX" Then 'Works fine
If Mdl or Mdl2 = "ZDX" Then 'Generates Type mismatch error

Does anyone know how to check more than one memory variable (Mdl and Mdl2)
against a string value?

Thanks,
RR