Macro has started crashing workbook

[CRIMEDOG]

This macro causes my Workbook to stop working and excel to search for fix.
Is there anything you see that might be the culprit?
I have it stored on my Personal.XLSB and run it on the open workbook.
There is no error message before the crash. AND it just recently started happening - previous to yesterday it worked flawlessly.

Please Login or Register  to view this content.

[LJMetzger]

Hi CRIMEDOG,

It looks good to me, except that there is no Dim statement for wsSheet. Try adding

Please Login or Register  to view this content.

It is a best practice to declare all variables. If you misspell a variable in your code, VBA will silently assume it is a Variant variable and go on executing with no clue to you that you have a bug. Go to the VBA development window, click Tools, Options, and check "Require Variable Declaration." This will insert the following line at the top of all new modules:

Please Login or Register  to view this content.

This option requires all variables to be declared and will give a compiler error for undeclared variables.

Lewis