autofill cells using percentages from another spreadsheet
Last November Graham Mayor provided me with a great deal of help linking 2 or 3 spreadsheets together - he provided me with a file called 'Process.xlsm. Since then I have modified what he gave me a couple of times to do similar things. Just yesterday I managed to get a whole year's data linked together for the Charity's accounts.
Unfortunately since completing that work when I now try to open the Process file I am getting a Run time error message (see attached) and it highlights a line in the Visual Basic (see the highlighted line in the Visual Basic code attached). The form for selecting the various files that I want to link no longer appears.
Can someone tell me what has gone wrong and more importantly what can be done to fix it?
|