I have the following code in a print macro:
The user will select multiple items in column n. The macro sorts and prints the selected items. If only one item is select my macro prints the entire worksheet. What I am looking to fix is it one item is select print that row after the sort, if multiple items, then print multiple items after the sort. Thanks in advance for any help given.
If Selection = "M65519" Then Endrange = "M35" Else Range("M35").End(xlDown).Select Endrange = ActiveCell.Address End If