about Used range from particular cell

[VBABEGINER]

Hello All board member,
It seems from very very long time on board..Happy to questioning..

Ok..

I have question like, after my c10 range, whatever be the rows data are there, will be clear..

Can anyone help me on this..

 

[Rick Rothstein]

This to working..

If there is a row number that you know you will never have data down to, let's say that row number is 20000, then you could do this as well...

[2:20000] = ""

Note: You cannot substitute Rows.Count for the 2000 (nothing from the VBA world can be inside the square brackets.