| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear an XML Map of all content
try this
Dim myListObject As ListObject Set myListObject = ActiveSheet.ListObjects(1) Dim q As Integer For q = myListObject.ListRows.Count To 1 Step -1 myListObject.ListRows(q).Delete Next q "DangerMouse" wrote: Hi, Is there a simple line of VB that can be used in a macro to delete all records from an XML map? Thnx -- DangerMouse ------------------------------------------------------------------------ DangerMouse's Profile: http://www.excelforum.com/member.php...o&userid=27755 View this thread: http://www.excelforum.com/showthread...hreadid=538053 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to clear up useless content within worksheet? | Excel Discussion (Misc queries) | |||
| Clear Cells Content | Excel Discussion (Misc queries) | |||
| How to clear clipboard content programatically | Excel Programming | |||
| Clear Columns Content | Excel Programming | |||
| Clear the content of a worksheet using VBA | Excel Programming | |||
Threaded Mode
