Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange Cell behavior redux
Terry,
I don't have the killer answer you're looking for, but it might help you to know you can do away with the confirmation dialog when deleting the sheet by using the statement "Application.DisplayAlerts = False". (Make sure to set it back to "True" after you delete the sheet). I've experienced strange behavior on worksheets when I have control buttons on them. I know this is not the case with you, but I thought I'd throw that in. The other strange thing I get a lot with vba in Win2K is having the OS shut down Excel because of a generated error. Almost exclusively, the problem is that it does not like a name I gave to a variable. Many times it is a variable beginning with the letter "i", which I use a lot to denote an Integer data type. Can't explain it, sometimes Excel is not completely rational <g. You might want to try giving the sheet a different name. Shockley "Terry von Gease" wrote in message ... One time previously I asked about this and didn't get much in the way of an answer. The problem still plagues me. There is a sheet in a workbook that: Is always hidden Is always unprotected Has absolutely no event procedures or any other code associated with it Is called 'scratch' and used for exactly that. Whenever something need sorting, figuring, listing, etc. the proper valued are set into the appropriate cells in the scratch sheet and dealt with from there. Values, formats, and formulas can be set into this sheet depending. Most of the time it works just fine but every now and then the very first cell, "A1", seems to go off into space. If you true to enter anything in this cell nothing shows up. Nothing. If you set a breakpoint at the start of the change event there is noting in the cell when VBA breaks at that point. The cell has no formatting other than the vanilla specifications one would expect of a vanilla cell. If you delete all of the rows on this sheet, if you delete all of the columns on this sheet, if you delete all of the cells on this sheet, 'A1" still refuses to contain anything. Manually deleting the sheet and adding a new scratch sheet or even copying the old scratch sheet and then deleting the original seems to snap it back into full functionality. Until it starts doing it again. There is no sequence of events that I can determine causes this, it just seems to happen every now and then. Doing the same programmatically does not necessarily clear it up. Besides you have to deal with that annoying dialog wanting confirmation that you really want to delete this sheet. In addition, when this cell gets like this a set cl=sheets("scratch").columns(1).find(empty,lookin: =xlvalues) returns nothing when the entire columns(1) is empty. This causes much confusion. Once again I find myself at wit's end, not necessarily a long journey these days. I need a cogent explanation or this behavior and a way around it. Or do I take a lengthof rope into the woods. -- Terry "I said I never had much use for one, I never said I didn't know how to use one." M. Quigley |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Strange Cell Format Behavior | Excel Discussion (Misc queries) | |||
Strange behavior | Excel Discussion (Misc queries) | |||
Strange behavior | Setting up and Configuration of Excel | |||
Strange behavior. | Excel Discussion (Misc queries) | |||
Help with very strange cell behavior | Excel Programming |