Macro execution halts

Sat, 10 Sep 2011 11:15:40 GMT

Is there any thing wrong with below snippet? Macro execution halts highlighting the fourth line, but no error messages. Please help

sub removeUnusedSheets(retain)

cntsheets= ActiveDocument.NoofSheets

for sindx=cint(retain)+1 to cntsheets-1

ActiveDocument.RemoveSheet sindx

end sub

Anonymous — Sat, 10 Sep 2011 11:40:02 GMT

It is possible that the sheet number doesn't exist or not properly created. To find out, add line

msgbox(sindx)

in the loop before your fourth line.

topic Macro execution halts in QlikView