In article , smartin
writes
Hi Colin, sorry for the late reply.
Without creating a user form, the approach I would take would be:

- Sub1 with input box to query user for the column, call and pass result to Sub2.

- Sub2 with input box to query user for min value, then leverage Application.Worksh
eetFunction.Rep
lace and the column reference obtained above to do the heavy lifting.

Sorry I don't feel like coding just now, post back if you get stuck!

Hi

OK I understand the feeling!

I see the logic in your outline above , but I'm afraid I don't have the
technical skills to code this. Maybe when you have more time available
you could assist. I'd be grateful for that.

Thanks again



Best Wishes


Colin