Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

last row

  Asked By: Bailey    Date: Nov 30    Category: MS Office    Views: 657
  

Does Excell have a code name for the very last row in the spreadsheet



Basically I want to write



If activecell= <name> then

.....



Instead of

If activecell = 65536 then

.......



Because I am worried about my code being used in the new 2007 excel

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Tommy Thompson     Answered On: Nov 30

: Does Excell have a code  name for the very last row  in
: the spreadsheet

Application.ActiveSheet.Rows.Count

Or just:

Rows.Count

Make sure you are in a spreadsheet, not chart.

 
Answer #2    Answered By: Adelmo Fischer     Answered On: Nov 30

Perhaps this information will be of help:

Identifying the Real Last Cell

 
Didn't find what you were looking for? Find more on last row Or get search suggestion and latest updates.




Tagged: