linking code across different workbooks
 

Hi
I created a workbook with a macro to enter data across diferent sheets.
This workbook has to be split up into different sheets.

The macro no longer works.

Please advise the declarations required and confirm that all macro range
references
now have to completely explicit ie. workbook(range).worksheet(range).range
etc.

Thanks