Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
Sub Pallet_Tag_PrintSelector() Dim printSelection As Integer printSelection = Range("PrintSelection").Value If printSelection = 0 Then Call Pallet_Tag_PrintAll Else MsgBox printSelection 'ThisWorkbook.Worksheets("Preview").PrintOut End If Range("PrintSelection").Value = "" End Sub Sub Pallet_Tag_PrintAll() Dim i As Integer Dim palletCount As Integer palletCount = Range("TotalPallets").Value For i = 1 To palletCount Range("PrintSelection").Value = i MsgBox printSelection 'ThisWorkbook.Worksheets("Preview").PrintOut Next 'i Range("PrintSelection").Value = "" End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Excel VBA inserting a formula||12||40|
|need help to look for||16||43|
|need count all combination||31||34|
|VBA how to delete all objects regardless of its type from all worksheets in workbook||5||25|
Join the community of 500,000 technology professionals and ask your questions.