Hi Guys,

I'm completely new to excel macros. I found this code on a site and tried to create a macro from it, however I keep getting the following error:

Compile error: Type mismatch.

This is what the code looks like so far. The machine is a 64-bit Windows 7 machine.

Any help would be seriously appreciated.

Please Login or Register  to view this content.