Run-time error '13' Type mismatch

Hi guys,

I've got a spreadsheet that contains macros that remove columns and re-format the contents of a report. The idea is that the users copy the report (in xls format) and paste it in this workbook and run the macros by clicking on a button. My macros assume the first row contains the first record

My users are not computer savvy and pasting the report in my spreadsheet by selecting any cell other than A1 will mean that my macros will pretty much butcher the report and the results will be useless. My solution was to unlock only cell A1 and protect the whole spreadsheet:

Please Login or Register  to view this content.

This way the users will not have other option but to select cell A1. My plan is that when they select A1 that would unprotect the worksheet so that they would be able to paste the report. This is the code I had in mind (notice I used the SelectionChange event; that may not be the best option but my knowledge on programming is limited):

Please Login or Register  to view this content.

The problem is that when I paste the report that immediately triggers the SelectionChange event and gives me an error message ("Run-time error '13': Type mismatch"). Anybody know what could be happening here?

Thanks!

A.

Hi alepag,

welcome to the forum. However, ...

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I'll add the code tags for you this time, but please use them from now on.

Maybe like this:

Please Login or Register  to view this content.

Yup, that would cause it to not work. Maybe like this:

Please Login or Register  to view this content.