"Run-time error '1004' : Method 'Range' of object'_Global' failed

Hello,

Ok so this is an error I often get. I know it is to do with specifying ranges properly but I really struggle with it.

So I have a spreadsheet with multiple worksheets. There are defined ranges on one of the worksheets. This worksheets is called Dividends

I have a macro which runs on this spreadsheet. Please see the code below.

Please Login or Register  to view this content.

When I press F5 on this macro it works fine. When I press F5 and run through the macros I want in sequence it works fine.

However when I run a macro that runs multiple macros across different worksheets in sequence I get the "Run-time error '1004' : Method 'Range' of object'_Global' failed and the Range("ExDividendYesorNo") is highlighted when i debug. Range("ExDividendYesorNo") is a defined name for the dividends worksheet only.

Could someone please suggest what I should put into the code to specify where the range is. It is a defined range in the 'Dividends' Worksheet only.

Help is much appreciated

It works on F5 because you are selecting your range. I do not know if this helps.

Please Login or Register  to view this content.

Hi,

No I am still getting the error :S

If you name range is created in one sheet, how is you then testing it all sheets? Could you please your sample