| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use Offset in formula
Glad I could help
"Alex" wrote: Great - thank you. "Mike H" wrote: Hi, ActiveCell.Formula = "=Text(" & ActiveCell.Offset(, 1).Address(0, 0) & ", ""mm/dd"")" note the addition of (0,0 after the address Mike "Alex" wrote: This is perfect except that I need the address to be relative. "Mike H" wrote: Alex, If I've understood correctly then try this ActiveCell.Formula = "=Text(" & ActiveCell.Offset(, 1).Address & ", ""mm/dd"")" Mike "Alex" wrote: I'm trying to write a formula in a cell, =Text(B1, "mm/dd") where B1 is the cell to the right of the cell I'm writing the formula in. Am I at all close with the following? It's not working. Thanks for your help. Selection.Formula = "=TEXT(Offset(rowOffset:=0, columnOffset:=1),"mm/dd")" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| OFFSET Formula | Excel Discussion (Misc queries) | |||
| 1 OFFSET FORMULA, I'M NOT SURE WHAT DOES IT MEAN!!!!!! | Excel Discussion (Misc queries) | |||
| Offset formula | Excel Discussion (Misc queries) | |||
| Offset in Formula | Excel Discussion (Misc queries) | |||
| Offset Formula | Excel Programming | |||
Threaded Mode
