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?
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.