View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
George Furnell[_2_] George Furnell[_2_] is offline
external usenet poster
 
Posts: 18
Default Where to place code that changes a cell value?

Good day,

I would like to know where to place my code, since placeing it in the module
section produces an error. The code is seen below. I need this code to
execute for the "current displayed" worksheet, but I do not believe that I
should copy it to ecery sheet, thats why I tried it in the modules.

Where should I put it to only have 1 location for the code?

Range("M5").Value = 5

I appreciate your help.

Kind regards
George