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
=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