Using a macro to make selection in a drop down menu
Help!
-----Original Message-----
Hi everyone,
I'm trying to record a macro to print off all my sales
reports. When i record the macro it doesn't record the
part where i make a selection from my drop-down. So it
ends up looking like this....
ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1,
Copies:=2, Collate _
:=True
ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1,
Copies:=2, Collate _
:=True
ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1,
Copies:=2, Collate _
:=True
ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1,
Copies:=2, Collate _
:=True
ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1,
Copies:=2, Collate _
:=True
ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1,
Copies:=2, Collate _
:=True
Which just ends up printing out the same page a bunch of
times. Does anyone know how i can tell excel in the
macro
how to make a selection in a drop down?
Thanks for any help!
- RJ
.
|