I have a user who created a macro that formats the cell color of the selected cell(s). The macro works fine until it's attached to a button. When the button is clicked the cell selector moves to a specific cell everytime and formats that one cell. Any ideas? Thanks.

Sounds like when the macro is attached to the button, Excel is using the currently selected cell as the object. Best way to make sure you change the cells you want is to mark them and name them as a range. Then use the range name as the destination for any formatting. Hope this helps.

I have developed a workbook that solves simultaneous equations using the Solver. When I try to record the process using Macro, and execute, the VBA editor pops up with an error message: "Sub or Function not defined". I can't program on VBA. Does anyone know if it is possible to automate the Solver option on Excel instead of going through Tools->Solver process every time?

I have developed a macro to assign different colour to a range of number ie: 0-100 blue, 101 to 200 red and so on. Using the "conditional" function. But this function only allow me to have 3 colours max. Is there a way i can increase this to 5 or more. thanks