| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Target cell - unexplainable results
My Worksheet_SelectionChange code includes:
.... If (Target.Column = 9 And Target.Offset(0, -4) < "PR") Then [line2] Target.Offset(0, -1) = StrConv(ActiveCell.Offset(0, -1), vbProperCase) ElseIf Target.Column = 9 And Target.Offset(0, -4) = "PR" Then Target.Offset(0, -1) = StrConv(ActiveCell.Offset(0, -1), vbUpperCase) End If .... Usually works okay, but sometimes (i.e., when Target.column=3), the code goes to line2 (as if the target.column was 9), and runs line2. What do you think is up? TIA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unexplainable XIRR #NUM! Error | Excel Worksheet Functions | |||
| Target cell reference moves when target is cut and pasted | Excel Discussion (Misc queries) | |||
| Unexplainable Formulas | Excel Discussion (Misc queries) | |||
| Unexplainable results from my vlookup | Excel Worksheet Functions | |||
| Unexplainable Duplicate Entries | Excel Discussion (Misc queries) | |||
Threaded Mode
