I have following macro code that works fine on excel 2007 however when I try this on excel 2010 it fails with error 1004 - Application-defined or object-defined error. This seems to be excel version specific but I am not sure what is the cause of this error.
Has anyone faced similar issues or...