If I want to filter for a value in some set of data, I can do Autofilter & pick the particular value, say 39, from the drop-down list of numbers present. If I record a macro that does this, its vba text will stay with the particular number, 39. Unless I can edit that macro, in the right way, this will confine said macro to only seeking the value 39 & nothing more. I have tried to edit the vba text so that the 'criterial' is the value in a specific cell or in a specific range name.
So far I've not had success - when I run the macro (edited that way), it just throws up all of the values - it does no filtering at all.
What would be the correct way to edit my macro line, does anyone know?
Examples:
- this line bring about no filtering.
whereas
- this works but is obviously 'too specific'.
Thanks for any help.
LotusMan
Bookmarks