Z
zestpt
I created a function with help from this forum that allows you t
traverse an autofilter range.
With this function i created two ranges of unqeual length from th
autofilter ranges in two seperate workbooks.
My questions is this. How can i traverse through both of these range
at the same time using the format
for each rng in FilteredRange1
if rng in FilteredRange2 = value then
'do this
end if
next rng
thank
traverse an autofilter range.
With this function i created two ranges of unqeual length from th
autofilter ranges in two seperate workbooks.
My questions is this. How can i traverse through both of these range
at the same time using the format
for each rng in FilteredRange1
if rng in FilteredRange2 = value then
'do this
end if
next rng
thank