REPOST: Easy question...visual basic cell offsetting from cell entry
Posted by Brad on February 11, 2002 11:22 AM
Hey guys, I need to figure out how to make a cell offset based on the entry in another cell. Basically I want to change this:
ActiveCell.Offset(-3, -2).Range("A1").Select
to something like this:
ActiveCell.Offset( "E6", "B2").Range("A1").Select
where E6 and B2 would contain intergers defining how far to move. How can I do this? I tried the above formula and it didn't work.
thx
Brad