[ExcelVBA] Re: Last cell

 

Hi

Unsure if i am understanding the problem correctly

Microsoft Excel saves only the part of each worksheet that is in use, meaning the section that contains data or formatting. Sometimes the last cell of a worksheet may be beyond the range of your actual used data. This issue may cause you to have a larger file size than neccesary, you may print extra pages, you may receive "Out of Memory" error messages, or you may experience other unusual behavior. Clearing the excess rows and columns to reset the last cell can help to resolve these issues. After clearing the excess save and reopen

Regards
Vi

--- In ExcelVBA@yahoogroups.com, "sspatriots" <sspatriots@...> wrote:
>
> 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, "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>
> > 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
> > >
> >
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (7)

Recent Activity:

• New Members 7
• New Files 2

Visit Your Group

----------------------------------
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

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___