Once I copy a lot of these if functions my excel file balloons into a monster over 15mb and becomes unusable. The problem is I have long if functions and also will need to copy down many of them to allow the user to enter lots of data. Is there some kind of option in VBA to update the spreadsheet for this?