Digita
10-05-2007, 02:56 PM
Hi there,
When a cell contains a long winded formula, it would be a time consuming task to manually go to each individual cell addresses within the formula to find out the values these input cells hold.
Would there be a quicker way by vba to extract the input cell addresses & exclude math operators such as: "+", "-", "*", "/", "(",")", "^", pure numbers and "&"? The cell addresses sometimes come with sheet prefix - eg Sheet2!A1. Once the cell addresses are extracted, they would be populated in some kind of a loop to jump to the individual cells one after another.
Thanks in advance for your thoughts and input. Have a great weekend.
Kind regards
KP
When a cell contains a long winded formula, it would be a time consuming task to manually go to each individual cell addresses within the formula to find out the values these input cells hold.
Would there be a quicker way by vba to extract the input cell addresses & exclude math operators such as: "+", "-", "*", "/", "(",")", "^", pure numbers and "&"? The cell addresses sometimes come with sheet prefix - eg Sheet2!A1. Once the cell addresses are extracted, they would be populated in some kind of a loop to jump to the individual cells one after another.
Thanks in advance for your thoughts and input. Have a great weekend.
Kind regards
KP