When I open an empty excel file, it's size is usually 80K
Bytes.
Why is my empty file too large?
Now do a Ctrl-End and you should be at the actual end of your data.
HTH
--
Regards;
Rob
------------------------------------------------------------------------
"Mike" <anon...@discussions.microsoft.com> wrote in message
news:2b2601c3e12e$b23922e0$a501...@phx.gbl...
Sub Reset_all_lastcells()
'David McRitchie, http://www.mvps.org/dmcritchie/excel/lastcell.htm
Dim sh As Worksheet, x As Long
For Each sh In ActiveWorkbook.Worksheets
x = sh.UsedRange.Rows.Count 'see J-Walkenbach tip 73
Next sh
End Sub
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"RWN" <NotL...@mts.net> wrote in message ...
--
Regards;
Rob
------------------------------------------------------------------------
"David McRitchie" <dmcri...@msn.com> wrote in message
news:%238Hy686...@TK2MSFTNGP09.phx.gbl...
> A macro solution that will reset the used cell range and not force
> deletions should you actually have formulas in hidden areas.
>
> Sub Reset_all_lastcells()
> 'David McRitchie, http://www.mvps.org/dmcritchie/excel/lastcell.htm
> Dim sh As Worksheet, x As Long
> For Each sh In ActiveWorkbook.Worksheets
> x = sh.UsedRange.Rows.Count 'see J-Walkenbach tip 73
> Next sh
> End Sub
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
<snip>
Didn't realize that John had a macro to do all the sheets as well,
but I prefer to have control over when something is going to happen.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"RWN" <NotL...@mts.net> wrote in message news:uuOYRf75...@TK2MSFTNGP11.phx.gbl...
I wasn't saying XL doesn't do what it's supposed to do, in fact (more
often than not) I've found that many of the problems I've had with xl
were my own fault!
Again, I was just curious as to how it determines that a cleared cell is
not the same as a deleted cell.
For all I know there's probably a good reason for its behaviour, and I
just can't see it.
And you're absolutely right about wanting to have control as to when
something happens.
Thanks.
--
Regards;
Rob
------------------------------------------------------------------------
"David McRitchie" <dmcri...@msn.com> wrote in message
news:uS7RXv7...@TK2MSFTNGP11.phx.gbl...