A type mismatch occurs when you try to assign incompatible data
to a variable. For example

Dim L As Long
L = "a"

will cause a type mismatch error because a numerical data type (L
As Long) cannot hold string data ("a").

It is impossible to diagnose your problem without seeing the
code. When the error occurs, have the client click the Debug
button (assuming the VBA Project is not protected), rather than
the End button. This will cause VBA to display the offending line
of code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Linking to specific cells in pivot table"
<Linkingtospecificcellsinpivottable@discussions.microsoft.com>
wrote in message
news:2725A258-84E6-41C6-BD1B-047C728993CC@microsoft.com...
> Hi - A client of mine is getting the "Runtime Error Type 13
> Mismatch" error
> when they execute a macro on a spreadsheet I created. Any idea
> on why this
> was created and how I might be able to correct this issue?
>
> Thanks,
>
> Robert