Getting an error when calling multiple subs from a single module

[Blackhawks]

Hello,

I have been working on this inventory project for the past month and it's working great, but I've tried creating a dashboard to get an overview of the whole system and to be able to control it from the dashboard. I've created a bunch of different modules (I have over 10) that each control a different aspect of the the workbook (i.e., broken down by worksheet and import/export). I'm not trying to create the Update macro for the dashboard. This macro will run a number of other subs from different modules in order to purge old items and update new items.

The bug that I'm getting now is when I run "PullSalesData.VBA_Read_External_Workbook" - this sub extracts data from another workbook and pulls it into the Sales Worksheet of the Inventory system. However, when it runs in the Dash Macro, it crashes. The problem comes down to this line =

Please Login or Register  to view this content.

This code is supposed to sort the data in the Sales Worksheet of the inventory system, but instead it wants to sort it in the dashboard, even though it's running on the Sales Module. Here's the dasboard macro:

Please Login or Register  to view this content.

[scottiex]

So are you saying it gets "oneRange" wrong?
maybe you need to at least show us where it defines "oneRange".

maybe step through the macro and confirm if that is the case.

[Blackhawks]

Well oneRange is part of the sub of DashPurchPull.purchPull, which only acts on the Purchasing Worksheet, but it acts on the Dashboard worksheet. Does that make sense?

[xlnitwit]

Hi,

You need to at least show us the full code for the routine that crashes since it appears that is where the problem actually is.