View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kirkm[_7_] kirkm[_7_] is offline
external usenet poster
 
Posts: 91
Default Nasty intermittent


VB code:

Dim frm As UserForm
For Each frm In UserForms
If frm Is frmLabel Then
If frmLabel.Visible Then Unload frmLabel
End If
Next


This works just fine 99% of the time. But ocassionally errror

frmlabel = <Object variable or With block variable not set

appears and the line highlighted is

If frm Is frmLabel Then

It's Ok on the next run though.

Anyone know what this might be?

Thanks - Kirk