Insert Row throws error "Insert Method of Range class failed"

so here's an interesting issue i'm running into.

I am running code from a module onto different worksheets in my workbook. Currently the code is all running on a single worksheet and I've been using Activecell.offset function to insert information from a userform to the worksheet.

currently if I try to do:

Please Login or Register  to view this content.

I get the error "INSERT METHOD OF RANGE CLASS FAILED"
other forum posts suggest that this is a way of inserting another row. Likewise if I just do:

Please Login or Register  to view this content.

it does select the correct row to insert below...

Am I missing something here? it can't be very difficult, maybe just another set of eyes will help.
Thanks

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.

Let me know if this works for you!

Thanks!

haha genius! I knew it had to be pretty simple. I just assumed that if *.entirerow.insert didnt work that using selection didnt work either..

Thanks!

Originally Posted by rvasquez

Try

Please Login or Register  to view this content.

Let me know if this works for you!

Thanks!

Thanks

What if I want to select several rows , and copy them/insert them down ? what would be the code ?