Print a dynamic range, "Range of Object Failed

Hello once again,

When this routine runs, it is giving me an error "Range of Object_Worksheet failed on the highlighted line of code. When debugging, it has the correct rows and columns defined and the locals window shows that the correct sheet is being selected. I created this by watching a you tube video and simply entering my worksheet names and ranges, his works, mine not so much.

I've made a few changes based on this error by others and it still fails.

Ideas?

Please Login or Register  to view this content.

Try change to

Please Login or Register  to view this content.

Thank you both for the replies. However, I feel quite stupid. The problem was that the routine was in a module and not the sheet code, moving the routine to the correct place allows it to work properly. Still learning...

It does select the range as it's supposed to, now I need to finish the process by adding the printing statements if that's what you mean. That's my next challenge!

While we're discussing this, how would I need to change the routine so it can be run from a command button on my Main Menu sheet?