Quote Originally Posted by Dr.Ile
Sorry for nontrasparent question. I'll try in a different way:
At the beggining of my procedure I don't know how many lines there will be. I get their number from running specific procedure. So, number of lines is dependent of my input in this specific procedure. Because of these dependenties I want write a procoderu who will first read the number of lines and then assign them event procedures or macros (your way).
Thank you
PS:Sorry for my language
I am again sorry, I am still not with you. By number of lines do you mean number of used rows in a worksheet? Or you are referring to number of lines of code of your procedure? If it is later case then I do not know what exactly you are referring to because I cannot visualise a situation where number of code lines can change. In the former case, are you saying that the number of rows used is not fixed and you want to write a procedure to first find out how many rows are used and once you know the number then you want to evluate those rows? There is a method called CurrentRegion which will return a used range and then using Rows.Count you could find out number rows in the range. Is that what you are looking for? Else you need to tell me what exactly is your application. Sorry for being such thick-headed.

A V Veerkar