Have you tried Recording a Macreo, then do what you want, then stopping the macro.
By doing that, it should give you the VBA behind what you want to do.