Brian

Sample code.

Public Sub gronk()
ccols = Range("A1").Value
rrows = Range("B1").Value
ActiveCell.Resize(ccols, rrows).Select
End Sub

On Wed, 18 Feb 2004 11:08:55 -0700, "Ed"
wrote:

Brian - If you can put your values into Strings, you should be able to use
ActiveCell.Offset(x,y) with x and y being the Strings. So if x and y are
the values in a cell, or the calculated results of a formula, or whatever
else set in a String variable, it should work.

Ed

"Brian Matlack " wrote in
message ...
When navigating with a macro:
Example: Activecell.offset(1, 0).Range("A1")Select
Can I somehow have the offset numbers refer to a value in a cell
therefor making them variable based on formula input?


---
Message posted from http://www.ExcelForum.com/