+ Reply to Thread
Results 1 to 12 of 12

Freestyle

  1. #1
    Valued Forum Contributor KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    925

    Freestyle

    I've prepared demo of solar system for my kids (2 birds with 1 stone, solar + excel possibilities).
    Forum accept attachments < 1MB, so if you want to check this out, download from here: http://s000.tinyupload.com/index.php...57925414326476

    All issues are very welcome.
    Last edited by KOKOSEK; 06-11-2019 at 07:59 AM.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    Excel 2007
    Posts
    5,797

    Re: Freestyle

    Nice.

    2 remarks.
    1. Use conditional compiling for earlier versions.
    Please Login or Register  to view this content.
    2. Sheet needs to be unprotected to work (at least in my case)
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  3. #3
    Valued Forum Contributor KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    925

    Re: Freestyle

    Good point with double declaration, thank you very much.
    It does not working with protection?
    Let me fix and check this out.
    EDIT: double declaration applied. Should works now. (http://s000.tinyupload.com/index.php...63032875093957
    Last edited by KOKOSEK; 06-11-2019 at 09:23 AM.

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    17,400

    Re: Freestyle

    Earlier I got compiler errors.

    Now after a few flashing screens, I get:

    Run-time error '-2147024809 (80070057)':
    The Specified value is out of range.

    Hope this helps.

    Pete

  5. #5
    Valued Forum Contributor KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    925

    Re: Freestyle

    Hmm, thanks Pete.
    Weird, it works on X365 in work and also at home on X2007.
    Pete: vba / sheet protection pass: solar.
    Could you find out which line / lines generates problems?
    Last edited by KOKOSEK; 06-11-2019 at 10:13 AM.

  6. #6
    Forum Expert
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    2013
    Posts
    4,291

    Re: Freestyle

    Nice one.
    Works fine for me in Xl2013

  7. #7
    Valued Forum Contributor KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    925

    Re: Freestyle

    Cheers Fluff.
    I understand that you did not spot any problems/errors?

  8. #8
    Forum Expert
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    2013
    Posts
    4,291

    Re: Freestyle

    No, no problems or errors, it ran quite happily for 365 days & reset back to day 1 & continued.

  9. #9
    Valued Forum Contributor KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    925

    Re: Freestyle

    That's good then. Cheers once more.

  10. #10
    Forum Expert
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    2013
    Posts
    4,291

    Re: Freestyle

    You're welcome

  11. #11
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    Excel 2007
    Posts
    5,797

    Re: Freestyle

    Pete: vba / sheet protection pass: solar.
    You let me crack the password two times myself and now you're giving it away.

    I had to change

    Please Login or Register  to view this content.
    And this
    Please Login or Register  to view this content.
    in order to run without errors.

  12. #12
    Valued Forum Contributor KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    925

    Re: Freestyle

    sorry bakerman2 Thanks you very much.
    I'll compare these subs to analyse differences.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1