Sort Operation Works when Macros are called manually, but not when VBA calls the Macros

I cannot open the .xlsb file on my system for some reason. However, often times when the condition you describe occurs, it is because the code either does not qualify all ranges with parent sheet references or it uses AcitiveSheet for a reference and the user has a sheet different than the intended sheet active at runtrime. Similar conditions can exist with Workbooks where more than one is involved. You should makke sure all range references are properly qualified to reflect the parent worksheet and workbook, where applicable. One way to handle that is to use Object Variables to hold your Workbook.Worksheet reference, then make sure that variable is used to qualify the range objects that are used in the code. As I said, I could not view the code in your file so it is difficult to offer any other advice at this point.

You should makke sure all range references are properly qualified to reflect the parent worksheet and workbook, where applicable

I think i've done this, but here is one of the two macros that work when I manaually run the macros, but which do not work when I initiate the macro with a VBA comman. Do you see any holes in my qualifiers?

Please Login or Register  to view this content.

I don't know what to say about you not being able to open the file. I just downloaded the file and opened it.

I agree with JLG Whiz,

Not referring to the specific sheet has tripped me up many a time in the past. It's too easy to step through a macro when de-bugging and observing the results when you keep the sheet in question as the active sheet. But if you run the maco when the sheet is not Active or referred to directly yuo;ll get anomalies.

Use instead

Please Login or Register  to view this content.

And always use VBA sheet code names rather than tab names. They're too easily changed and a macro will fail if the tab name is hard coded.

I don't know what to say about you not being able to open the file. I just downloaded the file and opened it.

I don't know what causes it either, but it seems to happen with just about any file except .xlsx and .xlsm extensions. I have checked my blocked file settings and it should be opening files with valid file extensions from 97 onward. But I get the 'Format not compatible' message. I am beginning to wonder if it is my system security that is screwed up.