View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier
 
Posts: n/a
Default warning: cannot change part of an array. how do I by pass this?

Hi Gwyneth

Select the complete range of cells with the array formula before trying to
do the edit.

Regards

Roger Govier


Gwyneth wrote:
When trying to change the array in a workbook, I am getting the message
"Cannot change part of array". I do need to change the array, I beleive I
can by pass this but am not sure how to do it. Any suggestions?