Excel - ERROR 1004.. Method Range of Object Worksheet Failed

Hello

New to VBA and I'm having trouble identifying where the error is in my code. I believe I have identified the relevant worksheets and checked all the named ranges and advanced filter. I have 2 workbooks that are identical however, I get this error in one and not the other. I have compared the codes and ranges and I can't see anything obvious.

Main Code:

Please Login or Register  to view this content.

Filter:

Please Login or Register  to view this content.

Both workbooks are identical so can't understand why one has an error and the other doesn't.
Unable to post workbook due to sensitive data. Any help would be appreciated.

Hi
Thank you for taking the time to read my post. The error occurs when clicking cmdIss. I copied the filter code above as it is called in the main code as a sub: AdvStkLoc
Not sure whether I'm doing this right or what I should expect, but I right clicked on the userform to display ALL the codes and it jumps to :

Please Login or Register  to view this content.

When I press F8 again it launches the userform as normal.

I did the same to the filter code and nothing happens there.

Amita

What line does the code stop at when you get the error? (ie: hitting debug on the error dialog takes you to the code and highlights it yellow, which line does it take you to?)

Without knowing where it fails and what the content actually is I would be hard pressed to give you a specific answer. Based on the error it generally means that the range you are referring to doesnt exist. There could be any number of reasons why:

• Invalid reference (like A100000 in an xls file) or a named range thats the wrong scope
• A vague reference (multiple named ranges with the same name but not implicitly calling it within scope)
• Trying to reference an empty or null range

Looking at just the code doesnt really tell us much. We have no idea what the underlying data is, on which line the error occurs, or external factors like difference in the 2 files (file type, storage location, etc).

Hi
Thank you for replying.
The error doesn't stop the code, everything still executes without any obvious problems. Everything is transferred to the sheets correctly. The error is not displayed as a Run Time Error and there is no End or Debug options, just An Error has occurred, Error 1004... Method Range of Object Worksheet Failed, contact administrator, it only shows an OK button. At the moment, I am grateful that the code still works as it would stop our Warehouse until fixed. I am also confused as I thought that having put Exit Sub before the error handler stops the code if there is an error.

The workbook with the error sits on a network drive for others to access, however it is not shared (I was horrified after spending months on learning and creating this inventory workbook that you are unable to share a macro enabled workbook!!). The warehouse are using Excel 2003 (soon to be upgraded to 2013) and I use 2013. The error did not occur until today. As the code still works, am I able to eliminate this error from popping up? Not sure if this is the right thing to do as I don't know if it could cause problems in other ways.

Thank you again for responding, any help would be appreciated.
Amita

Ah the code has an error handler. Do this...

Open the VBA editor (Developer | VBA) or Alt+F11. Go to Tools | Options and select the general tab. Select the radio button "Break on all errors". Hit ok, close the VBA window and re-run. You will now get the dialog with a debug option. Be sure later to go back and change the option back to "debug on unhandled errors" (or whatever you had it set to).

Then let us know which line it stops on.

Thank you. Yes, I added the If statement and this as eliminated the error.