user input into active excel macro- prompt - respond -insert-cont
 

I am trying to create a prompt for manual input of filter selections in the
macro, for both the primary and secondary filter settings.

user input into active excel macro- prompt - respond -insert-cont
 

As always, post your efforts for comments.
Have a look in vba help for INPUT

--
Don Guillett
SalesAid Software

"Richard Duke" <Richard wrote in message
...
I am trying to create a prompt for manual input of filter selections in the
macro, for both the primary and secondary filter settings.