Print a range in a worksheet using a UserForm button

Hi, Print from user form cmdPrint The print range I need is from sheet "Data", displayed in vb listbox (OutputBox) is from "N10:V10" down to any row to "N9955:V9955 depending on results of various searches.
Hope this makes sense. Very new and have muddled my way thru this far.
Edit: Removed sensitive data and attached the file in the hope of getting some help.

Thank You

The file self destructs when attempting to allow editing. You need to disable the autorun macros and then upload the file.

Hi thanks for the reply. Yes I understand. I posted a copy so no problem. Trying to find my way around this forum. Should I be searching somewhere for a file from you?
Regards
Edit: Use the "HIDE" button bottom right of the form to close the form!

Well, I got the file open and took a look at it compared to the OP. I did not see anything in OutputBox, I don't want to spend a lot of time analyzing your entire project just to print a range from a sheet. Here is the gist of what you would need to print a variable range when only the starting row is known.

Please Login or Register  to view this content.

Depending on what is actually in the listbox, you might be able to use variables instead of hard coding the sheet and range parameters into the code, but like I said, there was nothing in the OutputBox control so I am not sure what you would be working with data wise to set up the variables. If the data always comes from the same sheet then that would allow you to use the sh variable as it is now. But if it varies and the sheet is identified somehow in the listbox then you would have to reference the listbox value to set the sheet variable. Same with the range parameters, thay would need to be initialized using listbox values. But at this point I am not sure how that would be done.