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