Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
PCLIVE wrote:
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" Then ' do something End If End Sub Or if not intersect (target, range("$A$1")) is nothing then .... it works if you are intereseted in area larger than single cell i.e. if not intersect (target, range("$A:$A")) is nothing then .... entire A column. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ISBLANK function not working when cell is blank dut to function re | Excel Discussion (Misc queries) | |||
Workshet onchange | Excel Programming | |||
OnChange Event for a Cell | Excel Programming | |||
OnChange - argh! How do I get this to work please? | Excel Programming | |||
Inserting time stamp onchange of any cell | Excel Programming |