This project has moved and is read-only. For the latest updates, please go here.

Delete cell range?

Oct 8, 2010 at 10:23 PM

I saw the worksheet.DeleteRow() method, but I couldn't find anything that allowed the user to delete a certain range of cells. Like I9:J15. Is that possible, or planned for a future release?

Oct 9, 2010 at 5:29 AM

Hi,

Range("I9:J15").Delete equals Cells["I9:J15"].Value = null;

but

Range("I9:J15").Delete xlShiftup

would require a bit of work. Not certain of jankallman's plans for this.

 

James

Oct 11, 2010 at 6:47 PM

Hi,

I have added a Clear method to the ExcelRange class. It deletes the cells but do not shift any cells.

I hope I can add that to a future version, but it will not be in the the next one.

Jan