Make .Offset pass over visible rows only?

[kaptenstofil]

Hi all,

I'm having a problem that seems simply enough but I'm having poor luck finding a solution on the internet.

Currently, I'm looping over a couple of criteria that filters a range.

During the loop I would like to split and assign the first visible value below a certain header, MemHeader, to a variable. What I have so far is this:

Please Login or Register  to view this content.

The only problem now, given that the range is filtered, is that the above code always chooses row number 1, which of course means that MemberID will always be the same.

So, is there a way of using .Offset and make it pass over only the visible rows?

Thanks and best regards,

[walruseggman]

Would something like this work? MemIDs would need to be defined by you, basically it would be the column of MemberID's.

Also, you said you wanted the first visible value, which would be Split(0), not Split(1)

Please Login or Register  to view this content.

[MickG]

Perhaps something like:-

Please Login or Register  to view this content.

[kaptenstofil]

Would something like this work? MemIDs would need to be defined by you, basically it would be the column of MemberID's.

Also, you said you wanted the first visible value, which would be Split(0), not Split(1)

Please Login or Register  to view this content.

Thanks mate, it worked!

Perhaps something like:-

Please Login or Register  to view this content.

I'll keep your solution saved for another project!

Thanks to the both of you!

[MickG]

You're welcome