OK, a poser for you... It's got me stumped
Three Dynamic ranges are defined as follows
All work fine and refer to the correct data
Formulas in my outputs spreadsheet are as follows
Where F9 has the value ACT04
Where F10 Has the value ACT04R
Where F11 has the value ACT04C
Now here's the issue....
When the formula was first constructed it worked fine. The coorect data was returned to my table from the dynamic range ACT04 using ACT04R and ACT04C as the dynamic column & Row references..
However, when i refresh the data using the following code
and rerun my query that repopulates the sheet.. even though the ranges are reset and appear to work, the formulas (that use INDIRECT) revert to a #REF error
Anyone know why this is and care to share this pearl of wisdom with me?
I thought it was all quite neat in theory...