I am writing a VBA program and need some help. I have an excel database that I sometimes nee to change the gross weight on. how ever I need to run it thrugh some math first. So I know the formula (Current gross weight per item on list/Old total gross weight * new total gross weight. my problem is is that I cant use cell numbers because the list of items always changes. And I need the new gross weight to display on other worksheets as well. I not sure how to make the program hold on to the old gross weight when the user is prompted to enter in the new gross weight.