Re^2: Repeating an Excel Formula in a row using Win32::OLE

This node falls below the community's threshold of quality. You may see it by logging in.

Comment on Re^2: Repeating an Excel Formula in a row using Win32::OLE

Replies are listed 'Best First'.
Re^3: Repeating an Excel Formula in a row using Win32::OLE by Corion (Patriarch) on Sep 15, 2008 at 13:55 UTC
You still don't show any effort. You need to tell us at least how your code fails for you and what you expect the code to do. Note that the `Selection` object depends on interactive features that may or may not be as you expect them. Your best bet is to replace all instances of `Selection` by absolute references. Most methods like `Open`, `Add` or `Range` return objects which you can use for replacing `Selection`. Also read the Microsoft Documentation on Excel.Range.AutoFill.	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^3: Repeating an Excel Formula in a row using Win32::OLE
by Corion (Patriarch) on Sep 15, 2008 at 13:55 UTC

You still don't show any effort. You need to tell us at least how your code fails for you and what you expect the code to do. Note that the Selection object depends on interactive features that may or may not be as you expect them. Your best bet is to replace all instances of Selection by absolute references. Most methods like Open, Add or Range return objects which you can use for replacing Selection.

Also read the Microsoft Documentation on Excel.Range.AutoFill.

[reply]
[d/l]
[select]