Variable Range

Posted by Thomas Venn on October 19, 2000 4:39 PM

Hi, this is my current code: ActiveCell.Range("A1:A1500").Select
I have a number in cell A1, which could be 300 or 5000 or 65000, and so on.
I want to know if there is a way for me to change A1500 into the value in cell A1.

Thanks in advance,

Thomas

Posted by Celia on October 19, 2000 5:25 PM

Thomas

ActiveCell.Range("A1:A" & Range("A1").Value).Select

Celia

Posted by Thomas Venn on October 20, 2000 1:16 PM

Thanks Celia,

Any suggestions for this: Application.Goto Reference:="R57000C29"
Same story, I want to change the 57000 to the variable in cell A1.

Thanks,

Thomas Venn

Posted by Joe on October 20, 2000 1:26 PM

Thomas,
Try this:

Application.Goto Reference:="R" & Range("a1").Value & "C29"

Joe Thanks Celia, Any suggestions for this: Application.Goto Reference:="R57000C29"