Well, that's a start on the code. However, folks are still left with having to guess about your code. For example, I'm presuming based on the syntax that you're using Win32::OLE rather than Spreadsheet::WriteExcel. Knowing which module you're using could help us figure out what may be the problem. (By the way, if you're using Win32::OLE, I'd personally argue that you don't need the macros since Perl can do the work instead. That's just my opinion though.)

Also, in your OP, you're referring to 'macros', but it looks like in your code that your really working with formulas. There is a difference between the two.

In the code that you provided, I believe your not providing correct data to the Range function in the next to the last line. That's where I'd start looking. However, since you didn't provide any more code, no one can tell what is actually being passed in.

I'm not trying to give you hard time. Just want to show you how the lack of code is really preventing others from providing help. As you can see above, I've got some thoughts about where to start looking, but I don't have enough info about your code to even give you any useful help.

In reply to Re: Excel Macro Writting Issue by dasgar
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.