VBA error 13:  Type mismatch


The data type for the variable is mismatched, i.e. expecting string but actually an integer.


Dim variableName as Variant

To fix you can Dim the variable as Variant.  Which will allow any data type for the variable.

Or make sure the actual data type for the variable matches the declared data type.


[efb_likebox fanpage_url="https://www.facebook.com/vbamarket/" box_width="840" box_height=340"" responsive="1" show_faces="1" show_stream="1" hide_cover="1" small_header="0" hide_cta="0" locale="en_US"]