D
Dale Fye
I want to compare the values of cells in a range, without actually selecting
the range. If so, what is the proper syntax? BTW, the sheet that the range
is on is hidden.
Private Function fnCompCells(rng as Range) as String
For each cell in rng
Dim myValue as string
If cell.value .....
'insert some comparison code here
endif
Next
fnCompCells = myValue
End
the range. If so, what is the proper syntax? BTW, the sheet that the range
is on is hidden.
Private Function fnCompCells(rng as Range) as String
For each cell in rng
Dim myValue as string
If cell.value .....
'insert some comparison code here
endif
Next
fnCompCells = myValue
End