+ Reply to Thread
Results 1 to 14 of 14

Run time error 91 on datas

  1. 03-23-2023, 03:27 AM #1
    MadMatLoco
    MadMatLoco is offline
    Registered User
    Join Date
    03-23-2023
    Location
    Paris
    MS-Off Ver
    365
    Posts
    8

    Question Run time error 91 on datas

    Good Morning

    Have a run time error 91 on my code but not every time

    using the find function to find a date then xxx.row

    Datas I'm looking for are timestamp, it is working between 10:00:00 and 12:45:00 but not before or after

    Find below the code, issue is on 'PUTTING TIME STAMP section
    Adding also 2 printscreen

    Need some help, it drives me crazy timexcel.PNGtimestamp.PNG

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 03-23-2023, 04:16 AM #2
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: Run time error 91 on datas

    Your code is not finding debut in Col R

    Please Login or Register  to view this content.
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  3. 03-23-2023, 04:21 AM #3
    MadMatLoco
    MadMatLoco is offline
    Registered User
    Join Date
    03-23-2023
    Location
    Paris
    MS-Off Ver
    365
    Posts
    8

    Re: Run time error 91 on datas

    Hi Sintek,

    trouver1 and trouver 2 are for column K not B
    My issue it is working for a certain time stamp but not for all and I'm sure the data to find is in Column K cos I have done a validation list....

    really drives me crazy ...
    Reply With QuoteRegister To Reply
  4. 03-23-2023, 04:24 AM #4
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: Run time error 91 on datas

    trouver1 and trouver 2 are for column K not B
    You mean Col R
    My post was amended prior to your response...
    See yellow manner above regarding sample file and explain what it is you are wanting to achieve...
    Reply With QuoteRegister To Reply
  5. 03-23-2023, 04:37 AM #5
    MadMatLoco
    MadMatLoco is offline
    Registered User
    Join Date
    03-23-2023
    Location
    Paris
    MS-Off Ver
    365
    Posts
    8

    Re: Run time error 91 on datas

    My bad ... did not see

    I want to find the correct Row but I don't understand why sometimes I have this runtime error for time prior 10:00:00 and after 12:45:00

    thx

    Mathieu
    Reply With QuoteRegister To Reply
  6. 03-23-2023, 04:42 AM #6
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: Run time error 91 on datas

    Can only ascertain once we see your file...Dates and times are tricky and often one has to manipulate...
    Reply With QuoteRegister To Reply
  7. 03-23-2023, 04:47 AM #7
    MadMatLoco
    MadMatLoco is offline
    Registered User
    Join Date
    03-23-2023
    Location
    Paris
    MS-Off Ver
    365
    Posts
    8

    Re: Run time error 91 on datas

    with pleasure
    how Can I add it ?
    Reply With QuoteRegister To Reply
  8. 03-23-2023, 04:51 AM #8
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: Run time error 91 on datas

    See Yellow Banner above thread...HOW TO ATTACH YOUR SAMPLE WORKBOOK:
    Reply With QuoteRegister To Reply
  9. 03-24-2023, 03:13 AM #9
    MadMatLoco
    MadMatLoco is offline
    Registered User
    Join Date
    03-23-2023
    Location
    Paris
    MS-Off Ver
    365
    Posts
    8

    Re: Run time error 91 on datas

    PRETRADE MB.xlsm

    U got it
    Reply With QuoteRegister To Reply
  10. 03-24-2023, 03:43 AM #10
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: Run time error 91 on datas

    And now...Explain the process as this file has no entries?
    Reply With QuoteRegister To Reply
  11. 03-24-2023, 04:02 AM #11
    MadMatLoco
    MadMatLoco is offline
    Registered User
    Join Date
    03-23-2023
    Location
    Paris
    MS-Off Ver
    365
    Posts
    8

    Re: Run time error 91 on datas

    So F11 / K11 is scrolling menu based on list on Markets worksheets

    F13/K13/P13 are scrolling menu with data who are not impacting the process of the macro

    G20 is Bloomberg ticker ie : ORA FP
    N20 is a number ie 50.000
    U20 is Buy or Sell



    Here the issue when I'm running the macro it is working between 10:00:00 and 12:45:00 but not if I'm putting an time stamp before or after
    Reply With QuoteRegister To Reply
  12. 03-24-2023, 04:31 AM #12
    MadMatLoco
    MadMatLoco is offline
    Registered User
    Join Date
    03-23-2023
    Location
    Paris
    MS-Off Ver
    365
    Posts
    8

    Re: Run time error 91 on datas

    Solved on my side
    Last edited by MadMatLoco; 03-24-2023 at 04:31 AM. Reason: Solved
    Reply With QuoteRegister To Reply
  13. 03-24-2023, 05:17 AM #13
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: Run time error 91 on datas

    Apologies for late response...Had an urgent matter to attend to...Yes, solved here too...
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  14. 03-24-2023, 05:22 AM #14
    MadMatLoco
    MadMatLoco is offline
    Registered User
    Join Date
    03-23-2023
    Location
    Paris
    MS-Off Ver
    365
    Posts
    8

    Re: Run time error 91 on datas

    Hope all is fine

    Thanks a lot
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Code runs in small datas but not working perfectly in bigger datas
    By RAJESH SHAH in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-04-2021, 10:28 PM
  2. compare oracle table datas and excel datas
    By james94539 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-01-2013, 03:48 PM
  3. Cross post >> Error on extracting datas from Pivottable with VBA
    By eloa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-29-2007, 07:41 AM
  4. Time-Datas to Time-Bars
    By tinastar in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-21-2006, 04:28 AM
  5. Transformation of Time-Datas
    By tinastar in forum Excel General
    Replies: 0
    Last Post: 09-21-2006, 04:25 AM
  6. sort certain datas in a wide range of datas
    By go4cdt in forum Excel General
    Replies: 2
    Last Post: 03-20-2006, 12:45 PM
  7. re : Finding the datas and deleting datas which are not found.
    By ddiicc in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-30-2005, 09:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1