When Last Cell needs to be reigned in to just below data, sometimes
Highlight/select Delete Save Close Excel Open Excel doesn't work?
Any ideas?
John

Are you deleting the info? You need to delete the rows/columnssave.

--
Don Guillett
SalesAid Software

" wrote in
message ...
When Last Cell needs to be reigned in to just below data, sometimes
Highlight/select Delete Save Close Excel Open Excel doesn't work?
Any ideas?
John

Don, yes, am Clearing then Deleting. Thanks for the response, John

"Don Guillett" wrote:

Are you deleting the info? You need to delete the rows/columnssave.

--
Don Guillett
SalesAid Software

" wrote in
message ...
When Last Cell needs to be reigned in to just below data, sometimes
Highlight/select Delete Save Close Excel Open Excel doesn't work?
Any ideas?
John

John

Are you selecting ALL rows below data and editdeleteentire row?

SHIFT + End + DownArrow to select from end of data to row 65536

Same for columns to the right?

Never heard of a case where this did not reset the last cell after
saving/closing/re-opening.

Visit Debra Dalgleish's site for macro to reset last cell.

http://www.contextures.on.ca/xlfaqApp.html#Unused


Gord Dibben MS Excel MVP


On Tue, 23 Jan 2007 14:15:01 -0800,
wrote:

When Last Cell needs to be reigned in to just below data, sometimes
Highlight/select Delete Save Close Excel Open Excel doesn't work?
Any ideas?
John

Gord,

I did do the Delete on both rows and columns using the little program below.
It was wierd because 4 out of 5 sheets worked fine, but the 5th wouldn't
give it up. Finally I think I found a fix for last cell on MS web site (URL
below).

Sub deletelastcellrows()
'Delete rows below data
Range("A500", "IV65536").Select
Selection.Locked = False
Selection.FormulaHidden = False
Selection.Clear
Selection.Delete

'Delete columns to right of data
Range("CT8", "IV65536").Select
Selection.Locked = False
Selection.FormulaHidden = False
Selection.Clear
Selection.Delete
End Sub

Method 2: Use an Excel add-in
An Excel add-in that removes excess formatting and resets the last cell is
now available for download. To download this add-in, visit the following
Microsoft Web site:
http://www.microsoft.com/downloads/d...displaylang=en
(http://www.microsoft.com/downloads/d...displaylang=en)

Gord, thanks for the help. This thing could pop up again. John


"Gord Dibben" wrote:

John

Are you selecting ALL rows below data and editdeleteentire row?

SHIFT + End + DownArrow to select from end of data to row 65536

Same for columns to the right?

Never heard of a case where this did not reset the last cell after
saving/closing/re-opening.

Visit Debra Dalgleish's site for macro to reset last cell.

http://www.contextures.on.ca/xlfaqApp.html#Unused


Gord Dibben MS Excel MVP


On Tue, 23 Jan 2007 14:15:01 -0800,
wrote:

When Last Cell needs to be reigned in to just below data, sometimes
Highlight/select Delete Save Close Excel Open Excel doesn't work?
Any ideas?
John