Insert data to last row of a range- VBA

Hello,

I am writing a code that prompts a user with an input box and then inserts this data into the last row of a defined range. I am having trouble finding the correct code to insert this data into the last row of my selected range.

Many similar topics show how to select the last row in an active range but I have been unable to find very much information regarding the last row of a selected range. The range I hope to select is not the last piece of data in the worksheet so XL (up) has been unsuccessful for me so far.

In other words, I am attempting to insert User defined variables A,B,& C into the next empty row of the three column range B5:D15.

Any information would be very helpful!

Thank you!

(This question has not been cross posted)