Hi!
I know next to nothing about vb programming, but nevertheless i have tried to compile a function it although contains an error which i can't identify.
Hope someone can and will help... thx![]()
Function Countcoloriftext(varRange As Range, subRange As Range, statustext As String, subText As String) Dim cell As Range Application.Volatile For Each cell In varRange If cell.Text = statustext Then For Each cell In subRange If cell.Text = strText Then Countcolorif = Countcolorif + 1 End If End If Next End Function











LinkBack URL
About LinkBacks
Register To Reply

Bookmarks