View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jive Jive is offline
external usenet poster
 
Posts: 34
Default Worksheet_Change

Hi I have what is probably the most basic question on the Worksheet_Change
module.
I need to write a script that copies a value from one cell to another when
another cell changes.

in this example I would like to change cell, L11, and have the script
replace the values in cells S11 and V11 with values from A1 and A2,
Similarly I would like to do the same for the range L11:L22 changing the
corresponding values S11:S22 and V11:V22 with the values from A1 and A2

Its probably really easy but I'm slowly learning the language and this seams
as good a place as any to start with worksheet events.

Thank you.