Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Absolute references
Great, thank you Tom
"Tom Ogilvy" skrev: sub ProcessData() for each cell in Range("A1:A5000") s = cell.formula s1 = Application.ConvertFormula( _ formula:=s, _ fromReferenceStyle:=xlA1, _ toReferenceStyle:=xlA1, _ ToAbsolute:=xlAbsolute) cell.Formula = s1 Next End Sub Change A1:A5000 to the range you want to process. Test this on a copy of your data and make sure it does what you want. -- Regards, Tom Ogilvy "Johan" wrote: I would like to create a macro that changes a formula in a cell to an absolute reference. Since I have a list of 5000 rows I want the VBA script to choose below cell after having changed the first one. I'm not into VBA so please keep answers on a dummy level. Greatful to answers / Johan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
Absolute References | Excel Discussion (Misc queries) | |||
Absolute References | Excel Worksheet Functions | |||
Absolute references | Excel Programming |