Macro's messing up calculations of named ranges

I have a rather large spreadsheet with 55 columns of which 24 perform logic calculations and when said and done could be upwards of 50,000 to 100,000 rows of data. I have made named ranges out of all columns to make my sumifs easier to work with. Problem is I have a couple of small subs to toggle the logic in a couple of columns and when I run them it trashes my calculations on another sheet of which I'm using the named ranges.

subs

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Just looking for some suggestions...
Thanks much

Originally Posted by 6StringJazzer

How are the named ranges defined?

What are the formulas that refer to the named ranges?

What do you mean by "trashes my calculations"? Are they giving wrong answers? Errors?

Thanks 6String for your question as it made me look a little closer and the answer was staring me in the face. I was not specifying the worksheet in the subs so it was overwriting my SUMIFS on the other worksheet with the inserted formula. I will try to be more diligent in solving my own problems before I ask for help next time. Will Mark solved.

Thanks again,

Don't worry--it's always obvious once you know the answer. Don't hesitate to ask questions--that's what we're here for.

I am delighted that you solved this just by thinking about the questions I asked.