Have received a spreadsheet which was originally in spanish and the VBA code was translated to english but none of the code will run, as I keep getting a run time error. Recorded a new macro and when tried playing it back same problem, error message as follows when trying to select a worksheet:
Run_Time_Error '-2147319784 (80028018)':
Method 'Select' of object 'Worksheet' failed
the same message appears if I even try to just select a range, any ideas?
Run_Time_Error '-2147319784 (80028018)':
Method 'Select' of object 'Worksheet' failed
the same message appears if I even try to just select a range, any ideas?