Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modify this a bit
I need to have this section of code modified to include a wide range of
W3:w6000, Z3:Z6000, AH3:AH6000. How would one accomplish that? See code that follows: --------------- Private Sub Worksheet_Change(ByVal Target As Range) 'Plugging the starting value in column Z and increasing it incrementally If Target.Address < "$AH$3" Then Exit Sub Application.EnableEvents = False Range("W3").Value = Range("W3").Value + 1 Range("Z3").Value = Range("Z3").Value + Target.Value Application.EnableEvents = True End Sub ------------------ THanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Modify code | Excel Discussion (Misc queries) | |||
Modify Code | Excel Worksheet Functions | |||
Modify a UDF please? | Excel Worksheet Functions | |||
Modify a UDF please? | Excel Worksheet Functions | |||
How would I modify the following? | Excel Programming |