Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use of "Formula" prt2
hello all...i found this code and would like to know the following:
ActiveCell.Formula = "=" & ActiveCell.Offset(0, -1).Address & " / " & _ ActiveCell.Offset(-1, -1).Address is there anyway to make one of the cells in the formula relative and not absolute? the result of this formula is (ie) "=$A$1/$B$1" and i'd like it to be something like "=A$1 / $B$1" Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use of "Formula" prt2
ActiveCell.Formula = "=" & ActiveCell.Offset(0, -1).Address(,False) & " / "
& _ ActiveCell.Offset(-1, -1).Address(,False) -- HTH RP (remove nothere from the email address if mailing direct) "Ernesto" wrote in message ups.com... hello all...i found this code and would like to know the following: ActiveCell.Formula = "=" & ActiveCell.Offset(0, -1).Address & " / " & _ ActiveCell.Offset(-1, -1).Address is there anyway to make one of the cells in the formula relative and not absolute? the result of this formula is (ie) "=$A$1/$B$1" and i'd like it to be something like "=A$1 / $B$1" Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use of "Formula" prt2
perfect!
thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to confirm entry in Col "C" is valid for data in Col "A" | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |