I know it's possible to set these 2 ranges to capture an entire row or column:
Range ("1:1")
Range ("C:C")
How would I do the same using variables if x = 1 and y = C? Please include the declarations as I am having trouble understanding if I can use string for y.
Bonus points, how do I select Range ("A1:A2") entirely with variables?
Thank you!
Bookmarks