Clearing a sheet

[Giordano Bruno]

This happens to me occasionally. I have a sheet which ends on column IV.

It should end at column J. I select all columns from column K to IV then delete them. (Edit > Delete)

I then park the cursor in A1 and save the sheet. That usually does the job, but just now and again it has no effect.

The sheet appears to be possessed. Does anyone have any have any other methods of casting out demons?

 

[tactps]

Alternatives:
1. An exorcist
2. Explain what you are doing to make this happen? Any macros for example? Any event handlers in the background?

 

[Smitty]

Here's a link to some code that work's like a charm:

http://www.contextures.com/xlfaqApp.html#Unused

HTH,

Smitty

 

[Giordano Bruno]

Thanks Tactps and pennysaver.

The code took off a formatted cell that I use but otherwise had no effect.

No. There are no event handlers running. They were the first thing to go.

In answer to the question "What an I doing?" All I am trying to do is to delete unused cells to reduce the size of the worksheet. Nothing that I try stops Ctrl-End zipping over to column IV.

 

[tactps]

I understand that you are deleting cells that should not be included - I am trying to work out what you are doing before that to make Excel think that they are used cells.

Any ideas?

 

[Giordano Bruno]

Hi tactps.

I have no idea how the problem occurred in the first place. The first thing that I noticed was that the scroll bar was indicating a very wide sheet. I suspect it was something that occurred when my back was turned. Excel does things like that when you are not looking.

I have resolved the problem in the meantime by painstakingly recreating the sheet from scratch.

Many thanks for your interest.