Hi

My brain will not function this morning. Here's the problem.
I am displaying a worksheet to the user with a set of transactions that
are to be selected if the goods have been received.
This is being filtered by a column not visible to the user, setting
autofilter for "Waiting".
Several non essential columns are being hidden, and I am inserting a
temporary column, with a list of checkboxes for the range visible, so
the user can tick items that have been received.
They may wish to apply a further filter to narrow the subset of
transactions to allow them to more easily see which are to be checked
off.
That filter may be released, and another applied and further checking
takes place.

When the process is complete, the user will click a button to "Update"
and I want to be able to change the status in the hidden column from
"Waiting" to "Received".
This I can do by comparing the status of the cell linked to the
checkbox, but how do I define the range to loop though, only including
those cells visible in the range the "I" have filtered by "Waiting",
having ensured that all other filters "they" might have applied have
been removed.

It's probably very simple, but I can't see it. Or, is there a better
way?


--
Regards

Roger Govier