Re: Determining how many rows have data in Excel 2003

  • From: "Bob Verity" <rtverity@xxxxxxxxxxxxx>
  • To: <jfw@xxxxxxxxxxxxx>
  • Date: Fri, 25 Jul 2008 23:22:13 -0500

another command that you may find helpful is Control shift C and Control 
shift R.

These will put in a list box all cells that have data in a column or a row.

----- Original Message ----- 
From: "Bob Verity" <rtverity@xxxxxxxxxxxxx>
To: <jfw@xxxxxxxxxxxxx>
Sent: Friday, July 25, 2008 9:39 PM
Subject: Re: Determining how many rows have data in Excel 2003


This will not exactly answer your question as stated, it will tell you what
the last row and last column on the sheet that has data.
----- Original Message ----- 
From: "Bob Verity" <rtverity@xxxxxxxxxxxxx>
To: <jfw@xxxxxxxxxxxxx>
Sent: Friday, July 25, 2008 9:17 PM
Subject: Re: Determining how many rows have data in Excel 2003


with Excel 2003 press control end then check the cell address with INSERT C
or CapsLock C if using laptop

----- Original Message ----- 
From: "Bill Tipton" <bill.tipton@xxxxxxxxxxx>
To: <jfw@xxxxxxxxxxxxx>
Sent: Friday, July 25, 2008 8:55 PM
Subject: Determining how many rows have data in Excel 2003


Is there a way to jump to the end of data within a Excel spreadsheet?

I want a quick way to determine how many rows have data in them within that
particular sheet.

I am using Jaws 9 and Excel 2003.

Thank you.

Bill

--
JFW related links:
JFW homepage: http://www.freedomscientific.com/
Scripting mailing list:
http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
JFW List instructions:
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: //www.freelists.org/archives/jfw

If you have any concerns about the list, post received from the list, or the
way the list is being run, do not post them to the list. Rather contact the
list owner at jfw-admins@xxxxxxxxxxxxxx

--
JFW related links:
JFW homepage: http://www.freedomscientific.com/
Scripting mailing list:
http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
JFW List instructions:
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: //www.freelists.org/archives/jfw

If you have any concerns about the list, post received from the list, or the
way the list is being run, do not post them to the list. Rather contact the
list owner at jfw-admins@xxxxxxxxxxxxxx

--
JFW related links:
JFW homepage: http://www.freedomscientific.com/
Scripting mailing list: 
http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
JFW List instructions:
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to 
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: //www.freelists.org/archives/jfw

If you have any concerns about the list, post received from the list, or the 
way the list is being run, do not post them to the list. Rather contact the 
list owner at jfw-admins@xxxxxxxxxxxxxx

--
JFW related links:
JFW homepage: http://www.freedomscientific.com/
Scripting mailing list: 
http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
JFW List instructions:
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to 
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: //www.freelists.org/archives/jfw

If you have any concerns about the list, post received from the list, or the 
way the list is being run, do not post them to the list. Rather contact the 
list owner at jfw-admins@xxxxxxxxxxxxxx

Other related posts: