Runtime Error "1004" Autofill Method of range class failed

i get a run time error when compiling a code and it points to this code below. Basically i need it to will only run it if you have 3 or more lines filled out on the form. if you have 2 it won't. Any help as to what could be done to change it so it can read 1 or 2 lines also.

Please Login or Register  to view this content.

new to VBA. I had posted but did not include the full code sorry bout that. Any help will be highly appreciated. The highlited part is where vb tells me the error is. So what this is that if there are less than 3 lines on the excel sheet being filled out it won't comply unless its 3 lines. How can i change it to take 1 or 2 lines also instead of only 3 or more. I have lots of this lines like this so i have to change them also.

Please Login or Register  to view this content.

Thank you for the help. I think your code worked thoough it gives me an error saying "compile error End If without block IF". when i take the End IF satement out, it runs fine but then goes to another segment in the code saying "Compile error Label Not Defined". Any idea why?

Originally Posted by JBeaucaire

A couple of ideas:

Please Login or Register  to view this content.