Thanks for all the suggestions.
As it turns out, the registry was never corrupted. It's just that when regscanw runs right after boot-up, it cannot get hold of the registry for some reason and then claims that it is bad. I disabled that app from automatically starting and it works like a champ...
Just wiped my HD clean (Fdisk and Format). After clean installing Win98 SE Upgrade, I get into a loop where when the GUI is finished loading, a message pops up saying that Windows found an error in the registry and needs to be rebooted to correct it.
So, I press OK, the machine reboots, and the...
Very good! After I posted the question I realized I never checked TechNet. The suggestion there was also to check the length of the text. If it's 2 characters long, the cell is empty...go figure!
It is good to know that Chr(7) is the EndOfCell Marker.
Thanks for the help.
dhover
If there is no text in the cell, Selection.Cells(1).Range.Text = "" returns False.
Why? Because it actually contains a CRLF combination (the end of cell marker?). This can be seen by print the Asc() of the text to the debug window: Debug.Print Asc(Selection.Cells(1).Range.Text)
Now...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.