Select Range of Cells Based on UserForm Input Value

[Drogan]

So I'm creating a UserForm that takes user input to create a worksheet based on the values input. My question is: How to select a range of cells based on a variable input value? For example, it asks how many competitors there are, and the user can input 5, 8, 10, etc. So I want that many cells in Row 1 selected, whatever the value input is. Thank you.

 

[Drogan]

Ok, I must've mistyped something last time, then, because even with the Worksheets value, it still went funky. But it works now. Thanks a bunch!!