Code enhancement help needed

[JayeshG]

Hi All,

I got a procedure which checks on precedents and dependents of a particular cell. Here is the complete code below. The results are displayed in Immediate window, instead I want the results in a new sheet added to the end of the sheet available. Can someone help me out with this.

Thanks!

Please Login or Register  to view this content.

Cross-posted here:
http://www.mrexcel.com/forum/excel-q...ml#post4164515

http://www.vbaexpress.com/forum/show...902#post324902

[protonLeah]

Please Login or Register  to view this content.

[JayeshG]

Hi protonLeah,

Your code works great! Do you have any idea, how we can get the same code to check for cell Dependents, if yes, how to modify the code. Can you help me on this?

Thanks!

[JayeshG]

Hi protonLeah,

Your code works great! Do you have any idea, how we can get the same code to check for cell Dependents, if yes, how to modify the code. Can you help me on this?

Thanks!

[JayeshG]

Hi protonLeah,

Sorry for the new things coming up. You helped me to get the dependents and precedents list in a new sheet, i want the same to add in a listbox or list view, or something similar, instead of a sheet. Can you be able to help me out. I tried it but not able to find a way.

Thanks!