Forum Discussion
Runtime Error '1004': Method 'Range' of Object '_Global' failed
Am trying to control "protection & FormulaHide" attributes of multiple cells and ranges and I get the following error: Runtime Error '1004': Method 'Range' of Object '_Global' failed Ranges: ...
Thank you so much HansVogelaar for your quick response, however tried that, but it still wont workit still won't work
Is the sheet you're applying this to protected at the moment you try to run the code?