Easy question...visual basic cell offsetting from cell entry
Posted by Brad on February 11, 2002 10:32 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 Mark O'Brien on February 11, 2002 10:51 AM
use conditional formatting on your due date cells
in the condition, put date < =now()
then select the format you'd like to see
Posted by Brad on February 11, 2002 11:02 AM
Mark, PLEASE REPOST...I can't read your reply!!! Bad link
Posted by Brad on February 11, 2002 12:12 PM
Mark, PLEASE REPOST...I can't read your reply!!! Bad link
Posted by Mark O'Brien on February 12, 2002 9:03 AM
I'm assuming the first line of code does what you want it to do. This code should take the values from E6 and B2 and use them as your offset parameters.
ActiveCell.Offset(Activesheet.range("E6").value, Activesheet.Range("B2").value).Range("A1").Select
