Hello
I can't get this snippet of test code to run. I'm referencing the range as I've seen on msdn with no luck. I get a 1004 "Application-defined or object-defined error". Help?
![]()
Sub NewButton_Click() Dim rng As Range With ActiveWorkbook.Worksheets("categories") rng = .Range("category") End With For Each c In rng MsgBox c.Value Next End Sub
Bookmarks