Hi Sahak,
I do have a macro to sort the spreadsheet as there is a number of different criteria I take into account, therefore to have an accurate answer for the Savings Value you MUST sort the file otherwise you just have a nice number. The code is attached to the CommandButton.
Your previous code gets the button to toggle the colour for each change made. Ideally what I want is if one or more changes are made then the button colour changes from GREEN to GRAY. Once it's GREEN I know the sort sequence is right up to date. There are a lot of calculations on the sheet so i want to avoid having it run the code for each change.
You mention using a loop which to me suggests comparing to some other field, is this the case. If so I don't think it would work as I'm overtyping the cell that it would compare to or would be adding new rows. In fact I insert rows as I haven't figured out just yet how to code the SUBTOTAL function to allow for a variying last row.
To get the correct answer I for the moment just have to stick with running the code.
Ultimately I will be migrating it all to Access 2007 as this file is just going to keep growing. The two problems I have are that I haven't fully decided on the final content and layout, and secondly I'm only getting my head around Access now so a long way to go !
Regards,
Ken