+ Reply to Thread
Results 1 to 5 of 5

Run-Time error '9' Subscript out of range [post in French]

  1. #1
    Registered User
    Join Date
    02-15-2024
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    1

    Run-Time error '9' Subscript out of range [post in French]

    Bonjour,

    J'ai ce message d'erreur que je re�ois sur certain poste quand j'ex�cute la Macro.

    Information:
    Fichier source: Liste d'employ�s regroup�s.xlsm
    Fichier avec Macro: Liste d'employ�s publique.xlsm

    But de la macro: Mettre ?* jour une liste d'employ� du Fichier avec Macro ?* partir de du Fichier source.

    Voici le DEBUG "Erreur": L'erreur est ?* la ligne #10


    Please Login or Register  to view this content.
    Attached Images Attached Images
    Last edited by 6StringJazzer; 02-15-2024 at 07:17 PM. Reason: please use code tags; updated title; moved thread

  2. #2
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    1,980

    Re: Run-Time error '9' Subscript out of range

    You're missing a t


    LastRowPublic = Workbooks("Liste employés publique").Sheets("Feuil1").Cells(Rows.Count, 1).End(xlUp).Row

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Run-Time error '9' Subscript out of range

    Moved from Hello..Introduce yourself
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Run-Time error '9' Subscript out of range

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however we recommend that you include code tags around your code.

    Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Guideline #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here.

    I have add them because it is your first post.

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Run-Time error '9' Subscript out of range [post in French]

    I strongly recommend to everyone that they use Option Explicit and declare variables. Doing so prevents a lot of bugs and runtime errors. This would have flagged the error noted by ByteMarks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Error code "run time error 9: subscript out of range
    By iBennett93 in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 06-28-2021, 05:03 AM
  2. [SOLVED] run time error 9 subscript out of range
    By UltimateNeo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-07-2019, 10:09 PM
  3. Run Time Error 9 : Subscript out of Range
    By vipul.halbe in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-03-2018, 03:54 AM
  4. Run time error '9': Subscript out of Range
    By mklindquist0815 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-30-2016, 12:35 PM
  5. [SOLVED] Run Time Error 9 - Subscript out of range
    By JRidge in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-31-2014, 07:49 PM
  6. [SOLVED] Run-time error '9': subscript out of range - error occurs on multiple computers except one
    By BrettE in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-06-2014, 11:19 PM
  7. [SOLVED] run-time error '9': Subscript out of range - WHY??
    By pastotnikr in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-31-2013, 03:31 PM

Tags for this Thread

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