In Range("A1") from Wb 1 placed a value
in Range("A1") in Wb 2 put = 'C:\FolderName\[SourceWbName.xls]WorkSheetName'!A1
after this...........
I placed my code in the private worksheet_change event,
when i place a new value in Range A1 in Wb1 so Range A1 in Wb2 changed to the new value, but the private worksheet_change does not do any work,
i.e. as if there is no an event happend
why my private code does not work?
How can i make it work?
yours
h