Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Mar 2003
    Location
    Sydney, New South Wales, Australia
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Long formulas with linked cells (Excel 2003)

    When you use cell.formula in VBA code, it returns an error when the formula is really long. This happens when the formula has many references to cells in another workbook and the referenced workbook is closed. Because the referenced workbook is closed, all the cell addresses have the full path added to the address. This means that the formula is now very very long and cannot be referred to with the .formula property.

    Is there a way around this, other than opening the referenced workbook?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Long formulas with linked cells (Excel 2003)

    I don't know of another method. You can always open the other workbook, manipulate the formula, then close the workbook again (all in code).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •