Embed the value in a cell within the offset command

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

ActiveCell.Offset(x).Activate


Offset works great when I put a value in for "x", but how do I make it look up the value in a worksheet cell "a1" and use that as the value for "x"
thanks in advance
 
biff,

ActiveCell.Offset(Range("A1")).Activate

Regards,
Kevin


biff said:
ActiveCell.Offset(x).Activate


Offset works great when I put a value in for "x", but how do I make it
Click to expand...
look up the value in a worksheet cell "a1" and use that as the value for "x"
 
ActiveCell.Offset(Range("A1").Value).Activate

Now I match Dave Peterson's answer in form given earlier this evening.

:-)

Regards,
Kevin
 
Back
Top