I'm trying to change the content of all pre-selected cells in my worksheet to the same number. The macro would only work on already-selected cells.
A message box would ask the amount to change all the selected cells to and would make the change once the user had made the entry and clicked OK. A change of font colour would be helpful to highlight the changed cells.
Can someone advise on some code to do this?
Grateful for any advice.
Bookmarks