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