Results 1 to 2 of 2

Thread: copy array formula

  1. #1

    copy array formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    dear all ,

    when i copy an array formula to range of cells then error message displayed "you cannot change part of an array formula" , it is possible to copy without dragging.

  2. #2
    Super Moderator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    633
    Articles
    0
    What you will need to do is delete the array formulae from all cells, then re-enter the amended version, then you can drag copy down.
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

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