Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
change a formula
Hi, is there a programming way to change this:
Cell A10=A2+B2 into this Cell A10=$a$2+B2 Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
change a formula
select the cell
hit F2 highlight the A2 part F4 - each F4 toggles through the absolute/relative combinations -- HTH Bob Phillips "jobra" wrote in message ... Hi, is there a programming way to change this: Cell A10=A2+B2 into this Cell A10=$a$2+B2 Thanks in advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
change a formula
The built in function
sForm = "=A2+B2" ? application.ConvertFormula(sForm,xlA1,xlA1,xlAbsol ute) =$A$2+$B$2 will not work on just one argument, so you would have to develop custom code to do the conversion. You can get the directprecedents ? Range("A10").DirectPrecedents.Address $A$2:$B$2 but this doesn't seem real useful in this case. ? replace(sForm,"A2","$A$2") =$A$2+B2 is a very specific solution. You would have to state your real need and what the conditions are. -- Regards, Tom Ogilvy "jobra" wrote in message ... Hi, is there a programming way to change this: Cell A10=A2+B2 into this Cell A10=$a$2+B2 Thanks in advance |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
change a formula
"Bob Phillips" wrote: select the cell hit F2 highlight the A2 part F4 - each F4 toggles through the absolute/relative combinations -- Thanks Bob, but do you know a way to program this into a macro? HTH Bob Phillips "jobra" wrote in message ... Hi, is there a programming way to change this: Cell A10=A2+B2 into this Cell A10=$a$2+B2 Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change formula in a shared worksheet without losing change history | Excel Worksheet Functions | |||
how to change formula in shared sheet without loss of change histo | Excel Worksheet Functions | |||
change color of all cells with formula or are part of a formula | Excel Discussion (Misc queries) | |||
copy formula down a column and have cell references change within formula | New Users to Excel | |||
How does Data Validation change with a formula change? | Excel Worksheet Functions |