Sub SelectPivot()Dim strWhich As StringstrWhich = InputBox("Whick pivot table?", "Choose Pivot Table", "Status")If strWhich = "Status" Or strWhich = "Pending" Then Sort_LC strWhichElse MsgBox "Must be 'Status' or 'Pending"End IfEnd Sub
Well yes, you could manually change that line but I assume you don't want to do that, so in this post of mine I provided a modified version of your Sort_LC sub which accepts a parameter that tells the sub the name of the table you want to use, and this post provides a sub that you would call instead of Sort_LC. I'm happy to answer further questions.
pdvsa
ASKER
Hi Martin, Thank you <Well yes, you could manually change that line but I assume you don't want to do that, ==>i do wish to only change that line.
Open in new window
Open in new window