MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


Posted by Juan Pablo G. on February 11, 2002 11:33 AM

Try with:

ActiveCell.Offset([E6], [B2]).Range("A1").Select

Juan Pablo G.