Macro to update contents of cell
I have created a very basic macro which adds 100 onto the value of the
current cell and have assigned it as an icon on my toolbar.
The macro works perfectly, however, I have to run the macro on individual
cells which, if I have a large worksheet can take quite a while. Is there a
way I can adjust/edit the macro so I can select a range of cells and it will
adjust them all at the same time?
I have extremely limited knowledge of VBA!!!
Thank you very much.
Louise
|