Problem: I have a workbook with multiple sheets. In one sheet, Say Sheet-B, there are basic data in multiple rows and columns. These data is linked into other sheets, say sheet-C, Sheet-D, Sheet F and Sheet G. I got a sample code from net which was running on windows 10 and listed all the dependents in a column of the source data sheet. However, at first, didn't worked in another system with Office 365. After few days when i tried (Office 365), it worked for a while but stopped again. Now it is giving an error as - Run-time error "1004" - Navigate arrow method of Range class failed. Can anyone help to rectify the problem or provide codes to list all dependents of the source sheet in a seleced column in that sheet. (Brief details of the file:
'written by Bill Manville
' With edits from PaulS
' Additional minor edits by Mike W to find dependents instead of presients and changed the
' output from a text box to the Depentent Test worksheet.
' this procedure finds the cells which are the direct precedents of the active cell
(The file is available on net. If the file is required, i can provide it) Thanks.
'written by Bill Manville
' With edits from PaulS
' Additional minor edits by Mike W to find dependents instead of presients and changed the
' output from a text box to the Depentent Test worksheet.
' this procedure finds the cells which are the direct precedents of the active cell
(The file is available on net. If the file is required, i can provide it) Thanks.
