Excel mis-behaving !

%3CLINGO-SUB%20id%3D%22lingo-sub-1920679%22%20slang%3D%22en-US%22%3EExcel%20mis-behaving%20!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1920679%22%20slang%3D%22en-US%22%3E%3CP%3E%22All%26nbsp%3B%20of%20a%20sudden%22%20-%20ain't%20that%20always%20the%20case%20!%20-%20Excel%20is%20mis-behaving%20!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20a%20bit%20of%20a%20novice%20-%20I've%20only%20been%20using%20Excel%20since%201994%20-%20and%20I%20have%20NEVER%20come%20across%20ANYTHING%20like%20this%20Challenge.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20started%20one%20more%20%2F%20new%20WorkSheet%20-%20part%20of%20a%20MUCH%20bigger%20exercise%2C%20with%208%20other%20(working)%20WorkShets%20in%20the%20same%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20had%20text%20in%20Cells%20B3%2C%20B4%2C%20B5%2C%20B6%3C%2FP%3E%3CP%3EPut%20cursor%20in%20Cell%20B3%3CBR%20%2F%3EPut%20cursor%20in%20Cell%20B4%3CBR%20%2F%3EPut%20cursor%20in%20Cell%20B3%3CBR%20%2F%3EPut%20cursor%20into%20Edit%20bar%20at%20the%20top%3CBR%20%2F%3EAdd%20a%20few%20characters%20on%20the%20end%20of%20the%20text%20-%20they%20appear%20in%20the%20edit%20bar%2C%20and%20in%20Cell%20B3.%3CBR%20%2F%3EPress%20Enter%3B%20amended%20text%20appears%20in%20Cell%20B3%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3Bcursor%20goes%20to%20Cell%20B4%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3BCell%20B4%20content%20appears%20in%20edit%20bar%3CBR%20%2F%3EPut%20cursor%20in%20Cell%20B3%20-%20B%20THREE%20-%20whose%20text%20now%20appears%20in%20the%20Edit%20bar.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20as%20usual.%3C%2FP%3E%3CP%3EBut%20now%20!%20-%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EPut%20cursor%20into%20end%20of%20text%20in%20edit%20bar%20and%20.%20.%20.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E.%20.%20.%20that%20part%20of%20the%20text%20in%20Cell%20B4%20-%20B%20FOUR%20-%20that%20overflows%20into%20Cell%20C4%20disappears.%3CBR%20%2F%3ENow%20add%20a%20few%20characters%20in%20the%20edit%20bar%20to%20the%20content%20of%20Cell%20B3%3CBR%20%2F%3EThe%20characters%20appear%20there%20-%20AND%20inserted%20INTO%20the%20text%20in%20Cell%20B4%20-%20B%20FOUR%20!%3CBR%20%2F%3EPress%20Enter%2C%20and%20the%20text%20in%20Cell%20B4%20re-appears%20unchanged%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20the%20changes%20appear%20(as%20they%20should)%20at%20the%20end%20of%20Cell%20B3.%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20Except%20that%20they%20now%20have%20the%20colour%20that%20they%20would%20have%2C%20were%20they%20in%20Cell%20B4%20!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20there%20is%20a%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EApart%20from%20anything%20else%2C%20Excel%20ignores%20my%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%3CSTRONG%3E%3CEM%3E%20Private%20Sub%20Worksheet_ChangeByVal%20Target%20As%20Range)%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3Eroutine%20-%20I%20inserted%20a%20Stop%20command%20at%20the%20start%20of%20the%20routine.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20-%20I%20started%20by%20copying%20the%20Sheet%20to%20a%20new%20file%3B%3C%2FP%3E%3CP%3Ethen%20I%20tried%20to%20%22Repair%22%20Excel%20itself%3B%3C%2FP%3E%3CP%3Eand%20then%20both%20the%20original%20Worksheet%2C%20and%20the%20new%20copy%20-%3C%2FP%3E%3CP%3Ebut%20to%20no%20avail.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20NOW%20-%20when%20I%20click%20on%20D%26gt%3B%20Compile%2C%20it%20reports%20re%3C%2FP%3E%3CP%3ERange(%22M2%22)%26nbsp%3B%20-%20Sub%20or%20Function%20not%20defined%20!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I%20guess%20the%20next%20step%20is%20to%20re-install%20Excel%20(office%20%3F)%20all%20over%20again.%3C%2FP%3E%3CP%3EAnd%20if%20so%20-%20I%20am%20warned%20that%20this%20would%20remove%20%22all%22%20my%20Settings%20-%20but%20what%20settings%20are%20these%3F%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20List%20%3F%3C%2FP%3E%3CP%3ECan%20I%20%22export%22%20them%20to%20re-insert%20them%20later%20%3F%3C%2FP%3E%3CP%3EAnd%20if%20so%2C%20how%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOR%20-%20is%20there%20a%20simple%20%22software%22%20solution%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1920679%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EHow-to%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Regular Visitor

"All  of a sudden" - ain't that always the case ! - Excel is mis-behaving !

 

I'm a bit of a novice - I've only been using Excel since 1994 - and I have NEVER come across ANYTHING like this Challenge.

 

I have started one more / new WorkSheet - part of a MUCH bigger exercise, with 8 other (working) WorkSheets in the same file.

 

I had text in Cells B3, B4, B5, B6

Put cursor in Cell B3
Put cursor in Cell B4
Put cursor in Cell B3
Put cursor into Edit bar at the top
Add a few characters on the end of the text - they appear in the edit bar, and in Cell B3.
Press Enter; amended text appears in Cell B3;

   cursor goes to Cell B4;

   Cell B4 content appears in edit bar
Put cursor in Cell B3 - B THREE - whose text now appears in the Edit bar.

 

All as usual.

But now ! -


Put cursor into end of text in edit bar and . . .

 

. . . that part of the text in Cell B4 - B FOUR - that overflows into Cell C4 disappears.
Now add a few characters in the edit bar to the content of Cell B3
The characters appear there - AND inserted INTO the text in Cell B4 - B FOUR !
Press Enter, and the text in Cell B4 re-appears unchanged;

    the changes appear (as they should) at the end of Cell B3.

    Except that they now have the colour that they would have, were they in Cell B4 !

 

So there is a problem.

 

Apart from anything else, Excel ignores my 

    Private Sub Worksheet_ChangeByVal Target As Range)

routine - I inserted a Stop command at the start of the routine.

 

So - I started by copying the Sheet to a new file;

then I tried to "Repair" Excel itself;

and then both the original Worksheet, and the new copy -

but to no avail.

 

And NOW - when I click on D> Compile, it reports re

Range("M2")  - Sub or Function not defined !

 

So I guess the next step is to re-install Excel (office ?) all over again.

And if so - I am warned that this would remove "all" my Settings - but what settings are these? 

Is there a List ?

Can I "export" them to re-insert them later ?

And if so, how ?

 

OR - is there a simple "software" solution ?

 

0 Replies