Professor Excel

Comments 3

  1. Nam

    How to use vba to find name with error to delete it?
    Thanks Henrik!

  2. Brian

    Deleting the names from the embedded file worked like a charm! Many thanks.

  3. David

    Is there a way (VBA or manually) add ranges in bulk from the XML file? For example, I would like to add references to over 30 individual cells (imported data source with monthly data) without having to go through the cumbersome process of finding and highlighting each one every time. My UI automatically opens the worksheet and does not let me simply type in the data. If I could just cut and paste text into an XML file it would be easier to bulk update/name ranges.

Leave a comment

%d bloggers like this: