part of macro works on wrong file - Why?

**masben** · 02-28-2013, 03:59 PM

Hi,

The code below is from a macro that collect data from a master file to a forecast file. At the end I have a bit of code (placed within *********) that adds a formula to certain cells. The problem is that the part of code works on the master file instead of the forecast file. I tought adding the wsMaster.select code would make the trick but it doesn't. Do you know how to fix this? Many thanks in advance.

All the best,
Martin

Please Login or Register  to view this content.

**JosephP** · 02-28-2013, 04:08 PM

the on error resume next is hiding the fact you can't select a sheet in an inactive workbook. move the line that closes the other workbook before your problem code or properly qualify your range objects

**masben** · 02-28-2013, 04:11 PM

Of course if anyone knows of a better way to add the sum formula to the right of all rows in a dynamic range you are most welcome to share that. In my file a like two sum formulas added to sum two different part of each row.
Thanks again!

**masben** · 02-28-2013, 04:13 PM

Originally Posted by JosephP

the on error resume next is hiding the fact you can't select a sheet in an inactive workbook. move the line that closes the other workbook before your problem code or properly qualify your range objects

Whao you are fast!!! Thanks I'll try that.
Cheers, Martin