| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Go to cell based on formula result
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Go to cell based on formula result
You were soooo close
Range("F1").Offset(,Range("D8").Select -- Charles Chickering "A good example is twice the value of good advice." "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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Go to cell based on formula result
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Go to cell based on formula result
I think you are missing a Bracket... You are soooo close <bg
Range("F1").Offset(,Range("D8")).Select -- HTH... Jim Thomlinson "Charles Chickering" wrote: You were soooo close Range("F1").Offset(,Range("D8").Select -- Charles Chickering "A good example is twice the value of good advice." "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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Go to cell based on formula result
Try:
range("F1").Offset(0, Range("D8").Value).Select 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 -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Go to cell based on formula result
You were soooo close, too <vbg
Range("F1").Offset(,Range("D8").value).Select (to the OP. I like the 0 in .offset(), but it's not necessary.) Charles Chickering wrote: You were soooo close Range("F1").Offset(,Range("D8").Select -- Charles Chickering "A good example is twice the value of good advice." "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 -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Go to cell based on formula result
Thanks for the quick reply. No seegar this time, eh? Trouble is, it didn't
work. However, Jim's reply did. Thanks to you both for keeping me sane. -- Jim T "Charles Chickering" wrote: You were soooo close Range("F1").Offset(,Range("D8").Select -- Charles Chickering "A good example is twice the value of good advice." "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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Go to cell based on formula result
Doh! Hazards of trying to type with 2 kids on yer lap I guess. tx
-- Charles Chickering "A good example is twice the value of good advice." "Jim Thomlinson" wrote: I think you are missing a Bracket... You are soooo close <bg Range("F1").Offset(,Range("D8")).Select -- HTH... Jim Thomlinson "Charles Chickering" wrote: You were soooo close Range("F1").Offset(,Range("D8").Select -- Charles Chickering "A good example is twice the value of good advice." "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 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula result based on Multiple IFs | Excel Worksheet Functions | |||
| VLOOKUP based on a formula result | Excel Worksheet Functions | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
| Selection based result formula | Excel Programming | |||
| Hiding cells based on formula result | Excel Programming | |||
Linear Mode
