Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Viveka Fischer   on Aug 27 In MS Office Category.

  
Question Answered By: Bryson Smith   on Aug 27

I tried this and received this error message:

Run-time error '424':

Object Required

The code I used:

Sub CollectionEmptyTry()
Dim Obj As String
Obj = Range("P17").Value

If Cells(1, 1) <> "" Then
CheckEmpty.Add Obj
End If

Set CheckEmpty = Empty 'generates error

MsgBox CheckEmpty.Count

End Sub

Share: 

 

This Question has 3 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Help with Emptying a Collection Or get search suggestion and latest updates.


Tagged: