I have a spreadsheet with a series of formulas in various columns. I now want
to delete some of the rows. How do I overcome the error message "you cannot
change part of an array"?

Select any cell within the array,
then press CTRL + "/"
(to select the entire array)
Now you can press Delete key to clear the entire array at one go ..

voila? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"wlfoote" wrote:
> I have a spreadsheet with a series of formulas in various columns. I now want
> to delete some of the rows. How do I overcome the error message "you cannot
> change part of an array"?