• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to print listbox contents

Status
Not open for further replies.

alinco

New Member
Hi, this might be what I need. 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. Sensitive data so cant really post the code. Perhaps a trained eye on the line below will help realize my needs.
=OFFSET(Data!$N$9,0,0,COUNTA(Data!$N$9:$N$9955),9) - This is where search results are gathered then go on to populate the list box in the userform and I then need to print after a Print Preview.
Hope this makes sense. Very new and have muddled my way thru this far.
Thank You
 
Status
Not open for further replies.
Back
Top