OK, I'll bite. It's late at night and I'm waiting for the bridge results to come out, so I'll try to turn my telepathy mode on. Excel has two ways of inserting rows and columns, even from the keyboard. If you try Insert | Cells (or its equivalent in 2007 or later), you will get the Excel menu that shows what I mean. The two modes are Entire Row/Column and what I call "Bill Gates Knows Best" mode. It sounds to me as if you want entire columns but are using BGKB. Your code should look something like $shtList->Range('zEndList')->EntireColumn->Insert;. This I have taken from another of my nodes, Re^3: Win32::Ole excel external data range, where I show the inserting of rows among other things.

Roboticus is right, though. You would get much better help if you showed the minimum code necessary to demonstrate the problem.

Regards,

John Davies

In reply to Re: Excel Macro Writing Issue by davies
in thread Excel Macro Writting Issue by sachin_p_ganjare

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.