Thread
:
How put Array in VBA
View Single Post
#
1
Posted to microsoft.public.excel.programming
K[_2_]
external usenet poster
Posts: 557
How put Array in VBA
Hi all, how can I make array work in below macro
Sub del()
For Each c In Sheets("Data").Column("A")
If c.Value < Array("XX", "YY", "SS", "ZZ") Then
c.EntireRow.Delete
End If
Next
End Sub
please can any friend can help
Reply With Quote
K[_2_]
View Public Profile
Find all posts by K[_2_]