Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet_Change
try this within your event
if target.address="$L$11 the range("a1:a2").copy range("s11:s22,v11:v22") end if -- Don Guillett SalesAid Software "Jive" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet_Change | Excel Discussion (Misc queries) | |||
Worksheet_Change help | Excel Discussion (Misc queries) | |||
Worksheet_Change - NEW to VBA | Excel Worksheet Functions | |||
Getting around Worksheet_Change() | Excel Worksheet Functions | |||
Worksheet_change won't run | Excel Discussion (Misc queries) |