What does the rows.count expression do

[amartino44]

Hello. What does this rows.count expression do?

Please Login or Register  to view this content.

[dilipandey]

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]

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

[dilipandey]

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]

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]

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]

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

[dilipandey]

cheers my friend ... thanks.



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

[HaHoBe]

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]

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]

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]

Thanks HaHoBe for sharing the knowledge



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