| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Target.Address Being One Of The Cells Of A Named Range
I have applied a name to a collection dispersed cells and want to use the
same as follows but require a correct piece of code for <<???: Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ws_exit: If Target.Address <<IS A CELL OF THE RANGE NAMED "CELLS" Then MsgBox "YES!" End If ws_exit: Application.EnableEvents = True End Sub -- Thanx in advance, Best Regards, Faraz |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| test dbl click 'target' is part of named range | Excel Programming | |||
| pass named range address into variable | Excel Programming | |||
| Can you use a Range $N$xx:$Q$xx in Target.Address? | Excel Programming | |||
| getting the absolute range address from a dynamic named range | Excel Programming | |||
| Address of named range | Excel Worksheet Functions | |||
Threaded Mode
