ActiveCell to a fixed row selection

Good afternoon,

I am looking for some guidance on the best way to be able to select a range from an activecell to a fixed Row on a sheet.

For instance, if the ActiveCell is A10 and I need to select to A10:I25, I know how to do this but I need the starting point to be dynamic, with the range end always being row 25. I don't know if this is possible and how to go about it.

Any pointers or code examples would be gratefully received.

Thank you,
Chris

Hi CK76,

Thank you for answering.

I am creating a quote template for a colleague, whom wishes there to be flexibility with the format/design.

So for this example, the quote table will populate range A5:I10 (so 4 rows for parts, plus 1 title row). Below this, from A12, I am looking to create a merged range to I25 (full Range being A12:I25) - however the number of parts quoted each time will vary so the starting position of the merged range should be dynamic, if possible.

This is will only be implemented for the first page and only if required.

Is this enough or do you need more detail?

Chris

Thank you very much, I will give it a go.