Copying a Range using Variables
Posted by Alane on December 13, 2001 4:55 PM
I'm trying to write a macro to copy a Range based on variables. For example, if the rows are always 1 to 10 I would normally use:
I would like to set variables to two cells on a data sheet. The data cells are B1 and B2. Each containing a number. I tried the following:
Dim RowStart As String
Dim RowEnd As String
RowStart = Range("B1")
RowEnd = Range("B2")
I'm obviously missing something...
Thanks for your help!