Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Precedents
Hi All,
I am writing a macro where I want to change the range of cells referenced in a formula to a new range. I was planning on trying to somehow get a string variable (called strRangeO) to be equal to the precedent cells the formula refers too and replace it with a new string variable (called strRangeN). strRangeN would be equal to the new selected range address as per below: strRangeN = Range(ActiveCell,ActiveCell.Offset(0,3)).Address(x lA1) My problem is that I can't seem to find the function that will let me populate strRangeO with the current address of the range the fromula refers too. Can anyone help? Brendan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Locking portions of a formula | Excel Worksheet Functions | |||
assign formula to another cell | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
I want to trace the precedents in a formula when they are on mult. | Excel Discussion (Misc queries) |