View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Louise Louise is offline
external usenet poster
 
Posts: 217
Default 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