How print out selected range by using combobox on userform

[Ali-M]

Hello
I want to print out specific range is existed in columns H:L by matching combobox1 on userform with name is existed under NAME header in column I
should print out from H:L for data is relating with name is matched with combobox1.
thanks

[jolivanes]

Private Sub CommandButton1_Click()
    Range(Columns(9).Find(ComboBox1), Columns(9).Find(ComboBox1).End(xlDown)).Offset(, -1).Resize(, 5).PrintOut
End Sub

[Ali-M]

great !
thank you so much.

[jolivanes]

Thanks for the update and good luck.