• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. Dr. Demento

    How to Embed Linked Values in a Chart?

    Laura, Unless I'm misunderstanding, a chart can be copied/linked between Excel and Powerpoint as well as an individual (or group) of cells (your summary). After you copy the chart/cells in Excel, use the small down arrow below the Paste in Powerpoint. Click Paste Special. Click the Paste...
  2. Dr. Demento

    Excel 2010 vs 2013 TableStyle naming

    Has anyone else noticed that the color schemes for Tables created in 2010 are different than those in 2013? From what I can see, the grey and blue (first and second styles) in each color grouping (1-7, 8-14, 15-21, etc) are the same; the remainder are a little off (2010 red vs 2013 orange =...
  3. Dr. Demento

    Convert macro output (formula) to VBA

    That's not really working. When I paste it directly, the text is red (presumably missing a " somewhere? o_O My apologies; I should have paid better attention to the source (VBAExpress.com), as it was there the whole time. Final code: Hyperlink_dynamic = "=HYPERLINK(""[" & strPath &...
  4. Dr. Demento

    Convert macro output (formula) to VBA

    Thank you. I will give that a try. Apologies for the belated thank you.
  5. Dr. Demento

    Convert macro output (formula) to VBA

    I'm stuck in how to replace a term with the appropriate VBA code. The goal is to have a dynamic hyperlink that changes not only anchor but also the Display Text. I realize the code as it stands is circular, but I can figure out how to make it work if I could only get the syntax correct. The...
  6. Dr. Demento

    How to re-arrange columns in pre-defined serial order

    @Tim, That is some tight coding, man. It's a bubble sort, yes?? Strong work!
  7. Dr. Demento

    How to re-arrange columns in pre-defined serial order

    Thanks! I love his songs (Wiki)
  8. Dr. Demento

    How to reduce time while trimming cells

    From the SpreadsheetGuru, I like this code because it evaluates the whole range at once. However, given the forced xlCellTypeConstants, it will convert any formula into a value. The function can be run from the Immediate window if desired. Public Function trim_all(gnr As Range) ' ~~ Trim |...
  9. Dr. Demento

    How to re-arrange columns in pre-defined serial order

    Using some work from p45cal, I posted a question like yours recently. Please note, there is one correction that I've incorporated in the code below (recent post). Apologies if I've left any subs out; I use a lot of custom subs and rather than include all the extras, I try to post using generic...
  10. Dr. Demento

    Re-arranging columns using Arrays

    Close, except it removes ALL spaces (3rd function in #3); but I think I like Cyberdude's solution better. Nice solution to the re-arranging of columns using arrays, btw; very slick!!
  11. Dr. Demento

    Re-arranging columns using Arrays

    And with those three little letters, all is fixed. Thanks, Debaser!!! I wish I had that kind of attention to detail at Zero Dark Thirty!!
  12. Dr. Demento

    Re-arranging columns using Arrays

    p45cal came up with an awesome response to this question in 2015 (response #5). However, I can't seem to get it to work; I thought it was working earlier but I believe had suppressed the error or hadn't noticed it. Below is the code I adapted from his. At the line where With...
  13. Dr. Demento

    Delete files in folder; keep last file of each day

    I will definitely take a look into those. Thank you so much!!
  14. Dr. Demento

    VBA - Save As Using Cell Reference

    I'm spit-balling here, but I'm curious if you changed your statement defining ClaimRef to this perhaps it might help: ClaimRef = Worksheets("Working File").Range("I1").value Although, I think Chihiro was right -- if you step thru the code, on the second iteration, does the cell update to the...
  15. Dr. Demento

    Delete files in folder; keep last file of each day

    One other question: How do I actually move the files identified under the Moved category?
  16. Dr. Demento

    Delete files in folder; keep last file of each day

    Marc L, Thank you so much! That works perfectly! Could you help me understand how it works? I'm not familiar with scripting dictionaries. I understand the array loop and the SPLIT function (I wasn't aware of the limit parameter before) but the .ITEM(SP), JOIN(.ITEMS), .REMOVEALL, and tests...
  17. Dr. Demento

    Delete files in folder; keep last file of each day

    I appreciate the input, but I guess I haven't made my need very clear. I am NOT in need of code to extract the filenames (although that is helpful in its own right). Instead, I'm looking for a way to identify the maximum with each group (latest time in each day) Tushar provided a method to...
  18. Dr. Demento

    Delete files in folder; keep last file of each day

    xlstime, Thank you for the file. Unfortunately, it' doesn't address my primary issue - how to identify the last file of each day. Since I have almost 1000 files, manually going thru the list is what I hoped to avoid. I was hoping someone could help me understand how to parse the time/date...
  19. Dr. Demento

    Delete files in folder; keep last file of each day

    I posted this at Mr. Excel but no one was able to provide what I was looking for. I'm hoping that folks here might have some ideas. I create a timestamped backup of my Personal.xlsb (filename & "_yyyymmdd_hhss") everytime I save it. As you can imagine, this leads to a lot of versions each day...
  20. Dr. Demento

    MATCH (or FIND) with multiple criteria and wildcards

    Excellent!! Thanks so much.
  21. Dr. Demento

    MATCH (or FIND) with multiple criteria and wildcards

    The scenario is that I'm looking within the header of a table/range and I need to identify each column so that I can apply various formatting/validation rules. The intent is that there only one header cell that contains any one of the listed criteria; it's up to me to ensure that there wouldn't...
  22. Dr. Demento

    MATCH (or FIND) with multiple criteria and wildcards

    1. Thanks 2. If I had three search criteria, how would the x formula change? Would I just have to add the additional criteria to the Array or would other changes be required as well? x = Filter(Application.IfError(Application.Match(Array("CRITERIA1","*CRITERIA2", "CRITERIA3"), rngHeader, 0)...
  23. Dr. Demento

    MATCH (or FIND) with multiple criteria and wildcards

    @Deepak, thanks for moving my question. I had thought of nested tests, but had shyed away. Appreciate the knowledge that that's an alternative, though. @jindon, thanks! Two questions: 1) is the variable 'x' a Variant (in the interest of Option Explicit) and 2) my original example listed the...
  24. Dr. Demento

    MATCH (or FIND) with multiple criteria and wildcards

    I originally asked this question at MrExcel but got no takers so I thought I'd try here. Using VBA, I need to find the .address of the cell within a header (rngHeader) that contains either "DoB" or "Birth*" ([Birth* = Birth or Birthdate or Birthday]; I'd like the seach/match to be...
  25. Dr. Demento

    Cannot copy/paste code from internet

    I took a look at how it's being pasted in Word (Options, Advance) - plain text! (which leads to spagetti) Once I changed to the Word defaults, it's now behaving; it loses indentation, but that's window dressing. So, I can copy into Word, but Outlook is still garbage; oh well. Look ma, no...
Back
Top