Re: [ExcelVBA] Last cell

 

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@yahoo.com>
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 (2)

Recent Activity:

• New Members 8
• 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

.

__,_._,___