Sincerely Thanks a million for both of your time and expert advice :-)
Jaylin
*****Jaylin Message ended*******


"broro183" wrote:


Hi Jaylin & Max,
fyi
While the following won't work in the case of your example it may be
handy to remember...
Another option which works if the formula & the dependent or precedent
are *both on the same sheet *is to press:

[ ctrl + ] ] (ie ctrl & closing square bracket) to go to the
dependents
[ ctrl + [ ] (ie ctrl & opening square bracket) to go to the
precedents

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=509700