OK, a poser for you... It's got me stumped

Three Dynamic ranges are defined as follows

**ACT04** =VisionACT!$A$3:OFFSET(VisionACT!$A$3,COUNTA(VisionACT!$A:$A)-1,COUNTA(VisionACT!$3:$3)-1)

**ACT04C** =VisionACT!$A$3:OFFSET(VisionACT!$A$3,0,COUNTA(VisionACT!$3:$3)-1)

**ACT04R** =VisionACT!$A$3:OFFSET(VisionACT!$A$3,COUNTA(VisionACT!$A:$A)-1,0)

All work fine and refer to the correct data

Formulas in my outputs spreadsheet are as follows

=INDEX(INDIRECT(F$9),MATCH($E14,INDIRECT(F$10),0),MATCH(F$8,INDIRECT(F$11),0))

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

value....

Anyone know why this is and care to share this pearl of wisdom with me?

I thought it was all quite neat in theory...

Thanks,

Will