Michal

Try naming the lines explicitly, eg. "mLine_xx"
ie. select a line then enter its new name into the Name Box

Kevin Beckham

-----Original Message-----
Hi,

I work with Excel to calculate some charts and tables
that are copied
and pasted to a PowerPoint with the automation.

One of the parts of these reports is to show an upward
arrow when
results grow significantly and arrow down when it falls
for each
element in the table.

I done this putting two visible arrows line objects in
every row of the
table. Then the formula checks the results and
accordingly hide
unneeded arrows using visible=false. (please see the
worksheet
attached, no code attached).

It works fine apart from one issue - I find it difficult
to work with
line OLE objects. I try to do it using the
name "Line_xx", where xx is
a number. Unfortunately numbers easily change if I modify
the workbook.
Moreover if I copy attached worksheet to another workbook
lines will
also change the numbering. On the other hand I have to
know what is the
number of the particular line as sometimes the
calculation vary between
factors.

I feel there must be an easy solution somehow I can't
see. I'l be very
thankful for any ideas.

Thanks a lot,


Michal

Attachment filename:
arrows.xls
Download attachment:
http://www.excelforum.com/attachment.php?postid=562396
---
Message posted from http://www.ExcelForum.com/

.