Re:
Range("C8:D15").Select
How would I write that with fixed rows and variable columns please?
As you quoted but also
Range("C8:D" & lc).Select
Note: Selecting should just about never be a requirement.
Google for instance
Why not using "select" in vba.
You should get lots of articles that'll explain why.