Thread: for each error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
xlcharlie xlcharlie is offline
external usenet poster
 
Posts: 37
Default for each error

I'm getting a variable not defined error using the following code:

Option Explicit
Private Sub UserForm_Activate()
For Each cell In Range("cpName")
If cell.Value < "" Then
lstMnemonic.AddItem cell.Value
End If
Next cell
End Sub

The same code works to populate another list box. Why am I getting this
error?