| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Offsets
A Lifesaver, that's what you are. Thanks.
-- Jon M. "OssieMac" wrote: Hi again Jon, Having another look at the code I am not sure you need the following line. If Target.Count 1 Then Exit Sub Also because the offset is the same for each Case you can code it like the following. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count 1 Then Exit Sub If IsEmpty(Target.Value) Or _ Len(Target) < 11 Then Exit Sub Select Case Target.Row Case 11, 23, 35, 47 Target.Offset(-10, 2).Select End Select End Sub -- Regards, OssieMac |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| offsets (I think) | Excel Discussion (Misc queries) | |||
| Countif & Offsets | Excel Discussion (Misc queries) | |||
| offsets - using ranges | Excel Programming | |||
| Named range using offsets | Excel Programming | |||
| average, array and offsets | Excel Worksheet Functions | |||
Threaded Mode
