“Dim myarray（）as String”VS“Dim myarray（）as Variant”

I'm always afraid to declare things as just Variants under the assumption that an unnecessary large amount of memory will be allocated.I'm always afraid to declare things as just Var