Pulling data from multiple spreadsheets using VBA

**tittiot** · 02-25-2010, 04:20 AM

Hi all,

I recently created 40 identical models (and I use this term very loosely ;P) to track the number of motorcycles created across 40 factories worldwide. The manager at each factory is responsible for filling out a separate spreadsheet each day with the number of motorcycles produced and some other detailed information for that factory.

Since I will be receiving all these models at the end of the week, I'd like to consolidate a couple pieces of data from within each model in a Summary report I've created without having to open each one individually. I've created a macro to pull, for example, cells A16, B102, C103:C105, etc. from each worksheet to create a consolidated summary.

I am very close to finishing and just have one problem that I'd like to run by you all: Within the "data pull" logic I tell the VB code to sum multiple cells but for some reason the macro crashes if the cell is empty. Is this a common problem that I should be accounting for? Here's the code in question:

Please Login or Register  to view this content.

**rwgrietveld** · 02-25-2010, 04:38 AM

We just opened a thread with the title what to avoid in VBA.

Cells is a property of a worksheet. Therefore I would like to see something like:

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

Having that said:

Please Login or Register  to view this content.

Without seeing the content you could be adding strings (is there any restriction in the entered data "Data Validation" for the production managers?

So

crashes if the cell is empty

not normally.

Of what type is Metric1