Hi,

I am a bit confused to determine declaration array set variable. If I change it to Variant, it working fine but as far as I know, we should declare variables of a specific type, rather than Variant. Also to avoid type of mismatch error.

Why it can't be declared as String? please help

Sub test()
Dim Evaluaters As String, Approvers As String

Evaluaters = Array("CCO", "HCA", "SCM", "HOC (Ap)")
 Approvers = Array("HOE", "SCEM", "CEM", "CA")
  
End Sub