Can Excel graph macro get variable data length?

[Halemani]

Hi all,
I have some data for report generation and that I am passing to a macro in excel which I have previously recorded.
But the twist is that the data length may vary and don't know how to pass the length to that macro.
I know how to call that macro.
But, How to pass the length of data? Like =Sheet1!$A$25:$A$38. The A$38 part must be a varying data.
I can use the Excel graph example in LV8.0(Personal.xls thing)

[Pie56694]

Hi Halemani,

Please see Passing LabVIEW Values to a Microsoft Macro, and let us know if it helps solve the problem.