Copy range downwards till certain cell

Thanks for helping Berlan,

Is it possible to get the result in column H instead of underneath the existing range?

In that case, try this:

Please Login or Register  to view this content.

That works fine Berlan.

is it possible to start from a selected cell?

Please Login or Register  to view this content.

In this example, you can select both your input and output range. Try this:

Please Login or Register  to view this content.

Happy holidays!

This is just awesome and will definitely use it in the future!
But for now I'd like the user only to select the starting cell from where on the range will be copied down till the 100th row.

Applying it to your latest code, which I am then unable to test properly without seeing more of the workbook, so try if this would work?

You will select the starting cell from where the range will be copied down to to the 100th row.

Please Login or Register  to view this content.

That's it!
Thank you so much for helping me out with this.
Happy Holidays!