Hi I currently have the following code that when I click on a pulldown menu it zooms in then when you clicks of zooms out.
What I want is to still zoom in but once I click on selection it zooms out and selects range B1:s10 and copys the selection.
I'm not sure if its possible to zoom out and...