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