HELP - run macro from any worksheet

**indik** · 06-02-2015, 05:24 AM

Hi

I have the following code and it works when I run it from a worksheet entitled "Full List". However I want to run it from another worksheet call "Active List" (completely unrelated worksheet but this is where I want to run all my macros from), but it comes back with a 'Run Time Error 1004 'Application Defined or Object Defined Error'.

Can someone help point out what I am doing wrong please? I cannot seem to spot it as I am sure there is something simple I need to change.

Please Login or Register  to view this content.

**Richard Buttrey** · 06-02-2015, 05:43 AM

On which line do you get the Debug error?

I think you'll need to upload the workbook so that we can see the request in context

**indik** · 06-02-2015, 06:21 AM

Hi

thanks for your reply. The error is associated with the following line:

Please Login or Register  to view this content.

I have attached an example of my issue. You will notice 4 visible tabs.

If you press the "Run All Macros" button on the first tab entitled "Full List" you will note the error coming up. However if you turn to tab entitled "Active List" where I have that specific code only (and it relates to that tab), it works fine.

The question I have is how do I modify the code so it runs from the first tab entitled "Full List".

The overall objective is to extract data based on specific headings (in this case numbers) into different tabs using one macro. It works, but is having issues when I change the tab it is run from.

Hope you can help