Delete Rows in an existing array in Excel

W

wlfoote

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"?
 
M

Max

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert Rows into an existing array 1
Excel MS Excel - MS Office 2010 0
Excel Help to copy information from one row at a time to another sheet 1
Array with excel sheet inside (need 2 code rows please) 3
Array constants different in greek locale 2
Copying an Array formula 3
Excel Access - importing an excel spreadsheet 0
Excel Wildcard in Excel array formula 0

Top