Nadia,
I’m a little late with a solution but any way, when I have a problem like that, I usually go into Excel and create a macro that does what I need then edit the macro with the VBA and see how it is done and what properties where affected.