Share via

Dynamic Range reference

Anonymous
2019-07-10T13:08:20+00:00

Dynamic ranges. Changed all dynamic range names to use ‘index’ instead of ‘offset’. Offset was reportedly causing #REF errors if rows deleted. That is not dynamic. Now using ‘index’ but excel still corrupting range references. Any help would be welcome.  very frustrating

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-07-10T17:42:11+00:00

    Hi Vijay

    appreciate your suggestion about sending a dummy workbook but i am afraid this will not be possible. I think the “dummy” would only be helpful if i were to submit the entire project together with all the VBA subroutines. Aside from the issue of anonymising a lot of demographic data (not just names and addresses), I am obliged to consider the question of intelectual copyright. I am sure the organisation I work for would not appreciate sharing all the coding and structure with the world at large.

    so, again with many thanks for your time, i think i am left with very few alternatives viz. either wait to see if anyone else comes up with the same problem, and a solution or carry on burning midnight oil and solve myself. Last hope (!) would be that microsoft recognise there is an issue and come up with a fix mmmmm.....

    best regards

    martelcs

    Was this answer helpful?

    0 comments