Search:

Type: Posts; User: blafarm; Keyword(s):

Page 1 of 3 1 2 3

Search: Search took 0.00 seconds.

  1. Google Sheets: Scripting Workaround for 50,000 Character Cell Limit?

    Problem:


    In Google Sheets, I use the IMPORTDATA function with an API call to a 3rd party data provider that frequently produces a text string that is longer than the cell limit of 50,000...
  2. Re: Google Sheets Script: Please Help with Global Triggers for onOpen and onEdit

    SOLVED

    This code solved the problem.

    A bit sluggish -- but it does the job.




    function onOpen() {
  3. Google Sheets Script: Global Triggers for onOpen and onEdit

    Hi,

    I am trying to accomplish two goals and would appreciate any advice:

    Goal 1

    When my Google sheet is opened, and every time it is opened, I would like the contents of Cell A2 to be...
  4. Re: How to Extract Multiple Sections of Text in a String, Between Two Repeating Words

    jtakw,

    I had to break my last PM to you into 3 parts (not 2 parts as I thought).

    However, I can't send the last part because your Inbox is full.

    Please let me know when I can resend it.
    ...
  5. Re: How to Extract Multiple Sections of Text in a String, Between Two Repeating Words

    Hi jtakw,

    I sent you a PM.
    Not sure if your Inbox is full.
    If you're just busy -- no problem.

    Thank
  6. Replies
    5
    Views
    260

    Re: Clearing Excel AutoFilter using VBA

    Thank you all.

    Question:

    If I only wanted to REAPPLY the filter when the Workbook was first opened -- or when it was refreshed via the VBA in my first post - how might that change the code?
    ...
  7. Replies
    5
    Views
    260

    Re: Clearing Excel AutoFilter using VBA

    Thank you both for your responses.

    Unfortunately, I am a complete novice in terms of VBA, so I don't know how to properly integrate something like this into my existing VBA code:


    With...
  8. Replies
    5
    Views
    260

    Clearing Excel AutoFilter using VBA

    I am using this VBA code to refresh my entire workbook at specific time intervals.

    As you can see, it is currently set to refresh every 60 minutes.


    Public RunWhen As Double
    Public Const...
  9. Re: How to Automate a Cell Value from TRUE to FALSE at a Set Interval of Time

    Well, I found one problem.
    Your original post included:


    End Ff
    End Sub

    Rather than:
  10. Re: How to Automate a Cell Value from TRUE to FALSE at a Set Interval of Time

    I should also mention that a Macro also does not work.


    EDIT: I take that back, I have the Macro working now (not sure what changed).

    Now I just have to understand why the code is not working.
  11. Re: How to Automate a Cell Value from TRUE to FALSE at a Set Interval of Time

    I see what you are saying. Thank you for testing that.

    I've tested that code with both the "ActiveSheet" naming convention --as well as the Worksheet CodeName ("Sheet2")

    So my modified code...
  12. Re: How to Automate a Cell Value from TRUE to FALSE at a Set Interval of Time

    Thanks very much for that.

    Unfortunately, it is not replicating the functionality of using the toolbar "Sort & Filter > Reapply" pulldown menu option.

    I can't seem to find how to call that in...
  13. Re: How to Automate a Cell Value from TRUE to FALSE at a Set Interval of Time

    Thank you BlueAure. I'll dig into this to see if I can make it work.

    By any chance, do you have any idea how I might be able to automate the "AutoFilter>Reapply" menu bar function when a cell...
  14. VBA: Dynamically Update Auto Filter Results

    I’m hitting a brick wall with a new sheet and wondering if anyone might have a suggestion.

    In short, my problem is that Excel’s Auto Filter mode is not dynamically filtering my sheet.

    When I...
  15. Re: How to Extract Multiple Sections of Text in a String, Between Two Repeating Words

    tyija1995,

    Sorry for the delayed response.
    Thank you too for your efforts in devising a solution for me.
    It is also an interesting approach that I need to spend more time with in order to find...
  16. Re: How to Extract Multiple Sections of Text in a String, Between Two Repeating Words

    sandy666,

    Thanks very much for all your efforts in creating this solution.
    It is a very interesting approach that I hope to use in a future sheet.
    However, my current sheet is built around a...
  17. Automate a Cell Value from TRUE to FALSE at a Set Interval of Time

    I've done a bunch of research, and I'm not sure a solution exists for this challenge -- but I would be grateful for any input from the forum.

    I have a sheet that displays financial news that is...
  18. Re: How to Extract Multiple Sections of Text in a String, Between Two Repeating Words

    Thank you very much jtakw.
  19. Re: How to Extract Multiple Sections of Text in a String, Between Two Repeating Words

    jtakw,

    Very sorry to hear of your loss. Sounds like a good friend you spent many years with. I've been there, and completely understand.

    I only needed help with a formula to extract the...
  20. Re: How to Extract Multiple Sections of Text in a String, Between Two Repeating Words

    Looks like my last post disappeared ...


    Hi jtakw,

    I'm sorry, but could you please help with a variation of the "Vertical" formula that you presented in your first post? (LINK HERE)

    The...
  21. Re: How to Extract Multiple Sections of Text in a String, Between Two Repeating Words

    jtakw,

    Absolutely excellent!

    Thank you so much for your time and patience.

    Cheers

    (sending you a PM)
  22. Re: How to Extract Multiple Sections of Text in a String, Between Two Repeating Words

    Hi jtakw,

    Thanks very much for this.
    I tried many options but would have never arrived at that.

    One small problem, the formula is deleting the colon (:) in the URL after "https" and before...
  23. Re: How to Extract Multiple Sections of Text in a String, Between Two Repeating Words

    Hi jtakw,

    You've been extremely helpful, and I thank you for your time.

    Unfortunately, I'm stuck on this last part of the puzzle.

    I don't know how to modify your formula to work with the...
  24. Re: How to Extract Multiple Sections of Text in a String, Between Two Repeating Words

    EDIT:

    I think I can see the source of the problem.
    In Excel, the WEBSERVICE call seems to be comma delimited, which is different than the Google Sheets IMPORTDATA call.
    ...
  25. Re: How to Extract Multiple Sections of Text in a String, Between Two Repeating Words

    jtakw,

    That works perfectly in Google Sheets.
    Thank you very, very much.

    For some reason, it does not seem to be working in Excel 365 on a desktop.

    Can you please suggest why that might be...
Results 1 to 25 of 59
Page 1 of 3 1 2 3