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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Precedents
Hi Brendan, If the formula is in A1, Range("A1").Precedents.Address returns the address of the precedents. Ken Johnson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Precedents
Ken,
I tried the code below and got an error stating that "no cells were found". I forgot to mention that the formula and the precedent cells are on different sheets of the spreadsheet. Can you suggest an amendment to your code below that may help? Brendan "Ken Johnson" wrote: Hi Brendan, If the formula is in A1, Range("A1").Precedents.Address returns the address of the precedents. Ken Johnson |
Reply |
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) |