What does the rows.count expression do

**amartino44** · 06-24-2013, 12:09 PM

Hello. What does this rows.count expression do?

Please Login or Register  to view this content.

**dilipandey** · 06-24-2013, 12:11 PM

Rows.count returns the total number of rows in Excel. So excel 2003 and earlier will return 65536 and 2007 version onwards will return 1048576.

And here code is selecting the next available row at bottom of column A.. . it is something like you go to a1048576 and press ctrl + up arrow and then you can move one cell down

Regards,
DILIPandey
<click on below * if this helps>

**AB33** · 06-24-2013, 12:13 PM

press ctrl + up arrow
will not work if you have blank rows in-between.

**dilipandey** · 06-24-2013, 12:16 PM

I guess it will travel through all blank rows and stop as soon as it touches any date available at up side.

Regards,
DILIPandey
<click on below * if this helps>

**AB33** · 06-24-2013, 12:21 PM

I have got data with 16000 rows and my last row is 16000, but If I insert a blank row in row 3, the arrow will stop in row 3.
I mean CRTL+shift +down

**dilipandey** · 06-24-2013, 12:26 PM

You have 16000 rows and then OP's code will select a16001 as I said it is something like pressing ctrl + up arrow from cell A1048576

I did not mentioned "ctrl + shift + down" as myself & OP's code both saying moving towards up side and I believe "ctrl + shift + down" will move the selected range downwards. Hope we are on same page

Regards,
DILIPandey
<click on below * if this helps>

**AB33** · 06-24-2013, 12:30 PM

DILIPandey,
Hope we are on same page.
Yes we are.

**dilipandey** · 06-24-2013, 12:32 PM

cheers my friend ... thanks.

Regards,
DILIPandey
<click on below * if this helps>

**HaHoBe** · 06-24-2013, 12:37 PM

Hi, dilipandey,

So excel 2003 and earlier will return 65536.

AFAIR Excel95 and earlier only featured 2^14 rows (16,384), from 97 to 2003 2^16 like stated, from 2007 on 2^20.

Ciao,
Holger

**amartino44** · 06-24-2013, 12:44 PM

I don't understand...This won't work if there are blank rows? It should work because it's looking for last row with data after going to the bottom of the sheet.

**AB33** · 06-24-2013, 12:51 PM

Amartino44,
I was trying to make this point:
Some people equate finding a last row with the key function of CTRL+shift+ down arrow key.

**dilipandey** · 06-24-2013, 01:15 PM

Thanks HaHoBe for sharing the knowledge

Regards,
DILIPandey
<click on below * if this helps>

What does the rows.count expression do

LinkBack

Thread Tools

Rate This Thread

Display

What does the rows.count expression do

Re: What does the rows.count expression do

Re: What does the rows.count expression do

Re: What does the rows.count expression do

Re: What does the rows.count expression do

Re: What does the rows.count expression do

Re: What does the rows.count expression do

Re: What does the rows.count expression do

Re: What does the rows.count expression do

Re: What does the rows.count expression do

Re: What does the rows.count expression do

Re: What does the rows.count expression do

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions