This is fundamentally an Excel question, not a Perl question. The best way to answer this is to search the Microsoft Excel documentation.

The method names and properties for the Excel modules generally parallel the VB documentation, though you may need to do some syntax related translation. You are likely to get better help if you show you've done part of the work by posting the VB version and your best try at translating it to Perl.

Best, beth