#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Solved!!
I don't know what has happened to my computer but today (after doing nothing) the Process file has started working again!! So, for the present, there is no need for any responses!
|
Tags |
process, run time error |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can I autofill cells using percentages from another spreadsheet? | Baldeagle | Excel Programming | 25 | 03-24-2016 03:05 AM |
Autofill Automation | Parkiee1981 | Excel | 4 | 03-15-2013 01:24 PM |
How to calculate percentages??? | fabthi | Excel | 3 | 04-13-2012 12:08 PM |
Charting percentages within a percent | Tom0822 | Excel | 0 | 03-05-2012 08:50 PM |
Need cells to autofill with color | Silver Rain 007 | Excel | 1 | 10-22-2009 08:19 PM |