View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Jim Tibbetts Jim Tibbetts is offline
external usenet poster
 
Posts: 74
Default Go to cell based on formula result

Thanks for the quick response, Jim. Your code worked perfectly. I knew I was
close, but I sometimes have trouble with concatenation.
--
Jim T


"Jim Thomlinson" wrote:

Range("F1").Offset(0, Range("D8").Value).Select

--
HTH...

Jim Thomlinson


"Jim Tibbetts" wrote:

Hi All - I have been playing with this and can't get it to work. I want to
move the cursor to the right based on the result of a formula in D8. Can
anybody steer me in the right direction?

Range("F1").Select
ActiveCell.Offset("0, " & Range("D8").Value).Select

Thanks
--
Jim T