Syntax for naming a range using 2 variables

[kirk70]

Im having trouble figuring out the syntax for using variables in a range. I have variables that define the top left and bottom right corners of a range that I want to copy to another sheet. For testing purposes Im just trying to select the area. Using what Ive got im getting an application-defined or object defined error. When I test my variables they are holding the correct addresses. What is the correct syntax for this supposed to be. Thanks in advance for your help

Sub range_variable_copy()

Dim address_top_left As String

Dim address_bottom_right As String
Dim copy_address As String


address_top_left = Range("a2").Address
address_bottom_right = Range("i17").Address
Debug.Print (address_top_left)
Debug.Print (address_bottom_right)


Range(Cells(address_top_left), Cells(address_bottom_right)).Select


End Sub