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!