Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
worksheet_change problems
What i require is when a member of the team types cancelled into cell
ROW then the colums for that N:T for that row are filled with N/A have tried the below code but with no joy Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = "G:G" Then Application.EnableEvents = False If Target.Value = cancelled Then Range("N:T").Value = NA Else Range("N:T").Value = False End If Application.EnableEvents = True End If End Su -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting around Worksheet_Change() | Excel Worksheet Functions | |||
Problems with "Worksheet_Change" | Excel Discussion (Misc queries) | |||
Worksheet_Change | Excel Programming | |||
worksheet_change vs. calculate, and worksheet_change not running | Excel Programming | |||
worksheet_change vs. calculate, and worksheet_change not running | Excel Programming |