If Then Else Statement

[Aaron]

I have the following code in a print macro:

    If Selection = "M65519" Then
        Endrange = "M35"
    Else
        Range("M35").End(xlDown).Select
        Endrange = ActiveCell.Address
    End If

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.

 

[Aaron]

I used this instead, thanks anyway for your help

    If ActiveCell = 0 Then
        Endrange = "M35"
    Else
        Range("M35").End(xlDown).Select
        Endrange = ActiveCell.Address
    End If