Variable number of rows in a macro

[CrazyHorse]

Hi all!

I'm trying to write a macro with a variable number or rows depending on the total number of rows the workbook has.

I tried like this:

Please Login or Register  to view this content.

but it gives me an error. The only way i was able to do it without error was:

Please Login or Register  to view this content.

but as u can see it has a fixed number of rows.

I'm not a 'pro' programmer in excel, i'm just starting learning, so any help is really appreciated!

thanks

[Kelshaer]

use the below code to get the number of used rows (r as an integer)

Please Login or Register  to view this content.

[snb]

Please Login or Register  to view this content.

Avoid Select & Activate in VBA

[CrazyHorse]

I tried this:

Please Login or Register  to view this content.

and also copy and pasted the solution of snb but in both cases i have an error at the Application.Run step (I guess when calling the number or rows/columns).

any ideas? thanks a lot ^^