PDA

View Full Version : draw arrows



ganeshr
07-27-2011, 02:54 AM
Hi there.i 've a code which find precedents of a formula. i want a code that draw arrows between the cells. For example, if the formula is entered as c7=e4+f9 . then the arrows should be immediately drawn from the cell e4 to c7 and from f9 to c7 after the precedent cells are shown. so far i 've run the code to display precedent cells.

Aflatoon
07-27-2011, 03:07 AM
Since that is built-in functionality, why are you replicating it?

ganeshr
07-27-2011, 03:30 AM
i just want to make VBA code to draw arrows between specific cells.

Aflatoon
07-27-2011, 03:41 AM
I understand but since
Range("C7").ShowPrecedents
will do that automatically, I do not really follow why you are trying to reinvent it.

Actuary1010
07-29-2011, 12:26 PM
Are you doing option pricing using Binomial model?