| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select case target.address
On Sunday, August 27, 2017 at 2:21:30 AM UTC-7, GS wrote:
Select Case Target.Address Case "I13": Range("ABC").Select Case "I14": Range("DEF").Select 'and so on... End Select 'Case Target.Address -- Garry Hi Garry, Had to add the (False, False) to Target.Address(0, 0), works great, pretty compact code also. Thanks, Howard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Case without Select Case error problem | Excel Discussion (Misc queries) | |||
| Can you use a Range $N$xx:$Q$xx in Target.Address? | Excel Programming | |||
| Using Target.Address in Excel 98 | Excel Discussion (Misc queries) | |||
| target address | Excel Programming | |||
Threaded Mode
