Posts by Robert B

    I arrived at a limited form of the results you want using the following code

    I have short cut the finding and allocating months and phases but maybe there is something you can use.


    everything you say is true, nonetheless whenever and wherever the code element "ActiveWorkbook" appears the error message follows. This occurs only on my laptop, my PC does not suffer the same problem. Is there a way of re-installing Excel/VB to recover what can only be a problem in the basic program.


    Error message reads Compile error: Expected function or variable.

    I have used
    myBook = ActiveWorkbook.Name

    ActiveWorkbook Close

    and each produces the same message

    Whenever I use the property "ActiveWorkbook" in VB whether entered directly or by using the Macro recorder I receive an error message. Has anybody any idea why this should be?