Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you use a Range $N$xx:$Q$xx in Target.Address?
This works:
If Target.Address = "$N$" & j Or _ Target.Address = "$O$" & j Or _ Target.Address = "$P$" & j Or _ Target.Address = "$Q$" & j Then Wouldn't this work (or do I jsut have the syntax down wrong)? If Target.Address = "$N$" & j & ":$Q$" & j Then |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Target.Address in Excel 98 | Excel Discussion (Misc queries) | |||
Target.Address Doesn't Work in Excel 97? | Excel Programming | |||
Target.Address syntax | Excel Worksheet Functions | |||
Ranges:Target in Worksheet_SelectionChange(ByVal Target As Range) | Excel Programming | |||
target address | Excel Programming |