How to add and delete row dynamically?

Jun 2, 2009 at 11:07 AM

Guys,

How to add and delete several row dynamically?

Do i need Redim() everytime?

Thanks.

Coordinator
Jun 3, 2009 at 6:39 AM

Yes, you should use Redim, or juse set RowsCount or ColumnsCount directly

Jun 10, 2009 at 12:51 PM
Edited Jun 10, 2009 at 12:51 PM

remember that after you setrowcount or redim, you need to initialize the cells (do a new Cel() on each cell in the new row or column).

Cheers