[mso] Re: Excel 2002 - Range of Data Question
- From: Wilson Baptista Junior <wilson@xxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Fri, 04 Jun 2004 14:15:12 -0300
Hi Christine,
after you delete the empty rows and columns you must immediately save the
workbook *before* you try again to access the last cell. If you don't save
the workbook Excel will retain the previous last cell information.
Wilson
At 17:17 3/6/2004, McDonald, Christine, Ms, DCAA wrote:
>I have an Excel sheet that takes up rows 1-1206, columns A-Z. The
>spreadsheet data was created in another program and exported to an Excel
>file. When I do a ctrl-shift end or down arrow, it goes all the way to
>the last row of Excel, 65???, even though there is no data. So I
>highlighted rows 1207-65??? and deleted them, then I did the same thing
>across to delete all the columns from row AA through the end. Even
>doing this multiple times, Excel still thinks there is data all the way
>to the last row. It makes it difficult to navigate through the data, as
>a small movement of the scroll bar moves the cursor a long way through
>the data. Also, I'm trying to create a macro, that needs to know where
>the end of the data is.
>Anyone know why I'm getting this behavior and if there is a way to get
>Excel to recognize where the data actually ends?
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
