I have a named range which is 6 columns wide and (say) 100 rows long.
I've got the following code where I am trying to filter out the range for "TaskID" and then build a string using the values of all the columns or matching rows.
For Each Row In rngComments
If Row.Value = TaskID Then
For j = 1 To 6
strComBuild = strComBuild & "- " & Row.Item(j)
strComBuild = strComBuild & Chr(13)
I have two questions really :
1 - How do I refer to each of the column values in the rows collection ?
2 - Is this the best way to do this ?
Thanks in advance.