[ExcelVBA] Re: Last cell

 

I used Ctrl + End.

--- 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 (3)

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

.

__,_._,___