I ended up using Debra Dalgliesh's "DeleteUnused" code. It wouldn't work for me all day until I just discovered that I had a second sheet in the workbook protected. File size dropped from 2.5 Kb to 173 bytes. Thanks.
--- In ExcelVBA@yahoogroups.com, <david.smart@...> wrote:
>
> Including over 65,000 uninteresting rows in VBA processing will most
> certainly slow things down.
>
> There are other ways of finding a bottom row, but they depend on what
> the sheet looks like.
>
> For instance, is there a column where you could do the VBA equivalent of
> Ctrl-Up from the very bottom row and have it always find the bottom of
> the data?
>
> Or is there a column where a Ctrl-Down from the top row would find the
> bottom of the data? (I.e. a column with no empty cells.)
>
> A Google search will find you several options for finding the bottom of
> the data in an Excel sheet.
>
>
> Regards, Dave S
>
>
>
> ________________________________
>
> From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On
> Behalf Of sspatriots
> Sent: Friday, 20 April 2012 10:21
> To: ExcelVBA@yahoogroups.com
> Subject: [ExcelVBA] Re: Last cell
>
>
>
>
> Forgot to mention. The worksheet isn't that busy, 100 rows used by
> perhaps 10 columns wide. The macro is very slow, so just looking to
> speed it up and I've been reading that those unused cells slow it down.
>
> --- In ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com> ,
> "David Smart" <smartware.consulting@> wrote:
> >
> > You haven't said how you are moving to "last cell", or otherwise
> determining
> > where it is. What is your code, and why is this location a problem?
> >
> > Excel will tend to remember the bottom right cell that's been used in
> any
> > fashion in the sheet, and doesn't care if that cell is no longer in
> use (or
> > even if its row and/or column has been deleted). You can see this if
> you do
> > a Ctrl-End on the sheet.
> >
> > Need to know why you want the bottom location, and what the basic
> shape of
> > the sheet is. There are more accurate ways of finding bottom cells,
> but
> > they depend on what is in the sheet.
> >
> > Regards, Dave S
> >
> > ----- Original Message -----
> > From: "sspatriots" <sspatriots@>
> > To: <ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com> >
> > Sent: Friday, April 20, 2012 6:46 AM
> > Subject: [ExcelVBA] Last cell
> >
> >
> > > Hi,
> > >
> > > I'm trying figure out what in my code might be causing the last cell
> be on
> > > the very last row and at column 'ET'. I'm hoping someone can give me
> an
> > > idea of what to look for in my code to determine what might cause
> these
> > > scenerios.
> > >
> > > Regards,
> > >
> > > Steve
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > ----------------------------------
> > > Be sure to check out TechTrax Ezine for many, free Excel VBA
> articles! Go
> > > here: http://www.mousetrax.com/techtrax to enter the ezine, then
> search
> > > the ARCHIVES for EXCEL VBA.
> > >
> > > ----------------------------------
> > > Visit our ExcelVBA group home page for more info and support files:
> > > http://groups.yahoo.com/group/ExcelVBA
> > >
> > > ----------------------------------
> > > More free tutorials and resources available at:
> > > http://www.mousetrax.com
> > >
> > > ----------------------------------Yahoo! Groups Links
> > >
> > >
> > >
> > >
> > >
> > > -----
> > > No virus found in this message.
> > > Checked by AVG - www.avg.com
> > > Version: 10.0.1424 / Virus Database: 2411/4946 - Release Date:
> 04/19/12
> > >
> >
>
>
>
>
>
> ----------
>
> Visit our website at http://www.ubs.com
>
> This message contains confidential information and is intended only
> for the individual named. If you are not the named addressee you
> should not disseminate, distribute or copy this e-mail. Please
> notify the sender immediately by e-mail if you have received this
> e-mail by mistake and delete this e-mail from your system.
>
> E-mails are not encrypted and cannot be guaranteed to be secure or
> error-free as information could be intercepted, corrupted, lost,
> destroyed, arrive late or incomplete, or contain viruses. The sender
> therefore does not accept liability for any errors or omissions in the
> contents of this message which arise as a result of e-mail transmission.
> If verification is required please request a hard-copy version. This
> message is provided for informational purposes and should not be
> construed as a solicitation or offer to buy or sell any securities
> or related financial instruments.
>
>
> UBS reserves the right to retain all messages. Messages are protected
> and accessed only in legally justified cases.
>
> [Non-text portions of this message have been removed]
>
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar