| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Target Offset?
Excel 2002, Win XP
Chip Pearson responded to a poster with a Worksheet_Change event macro that included the line: Target(1, 4).Value = Now The Target(1,4) term is new to me. I played with it and it acts like an Offset of (0,3). What does the (1,4) in Target(1,4) mean? Thanks for your help. Otto |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Target.Offset(0, 36).Value Help | Excel Discussion (Misc queries) | |||
| Target.Value | Excel Worksheet Functions | |||
| Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul | Excel Worksheet Functions | |||
| Target cell reference moves when target is cut and pasted | Excel Discussion (Misc queries) | |||
| Target | Excel Worksheet Functions | |||
![Otto Moehrbach[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
