How to delete a row in a list

[xapwing]

Hi,

I try to delete a row in a list by row number (i), like so:

Worksheets(am).ListObjects(1).ListRows(i).EntireRow.Delete

But it appears to be wrong.

Any help appreciated.

Regards,
Arie

 

[GS]

Hi,

I try to delete a row in a list by row number (i), like so:

Worksheets(am).ListObjects(1).ListRows(i).EntireRow.Delete

But it appears to be wrong.

Any help appreciated.

Regards,
Arie

Way more info needed!!

Where is the list?
In a listbox control or a range of cells;

If a listbox control, where/how does the list get populated?
Via a range RowSource or manually entered as in a DV dropdown;

Where's the rest of your code?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[xapwing]

Op vrijdag 25 oktober 2013 16:31:54 UTC+2 schreef (e-mail address removed):

Hi,



I try to delete a row in a list by row number (i), like so:



Worksheets(am).ListObjects(1).ListRows(i).EntireRow.Delete



But it appears to be wrong.



Any help appreciated.



Regards,

Arie

Found the solution:

Worksheets(am).ListObjects(1).ListRows(i).Delete

Thanks for the help,
Arie