• 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.

Recent content by SirJB7

  1. SirJB7

    Need help with "Compile error: Expected: named parameter"

    Hi, Eloise T! As Chihiro told you above: A trick for persons with ADHD (aka Attention Deficit Hyperactivity Disorder) is this: a) double all quotes in formula b) embed a) into quotes. Regards!
  2. SirJB7

    Need help with "Compile error: Expected: named parameter"

    Hi, Eloise T! - OP: original poster, person who started a thread. - whenever faced with an Excel constant between xl and x1 go for xl of Excel. - what's LEN in that formula? you could use something like: If Len([L3])<>9 then and it works. Regards!
  3. SirJB7

    Application.EnableEvents Help?

    Hi, CarolineGMartin90! Welcome to Chandoo forums! Checked this yet? http://chandoo.org/forum/forums/new-users-please-start-here.14/ About your question, consider uploading a sample file or a clean & readable VBA code. It'd be easier to understand for people who might be able to help you...
  4. SirJB7

    Upgraded forums - Old VBA codes & formula handling

    Hi, shrivallabha! One of the jewels of the crown... old times, good times, time passes by... Thanks for bringing this from the time tunnel. Regards!
  5. SirJB7

    Compare 2 columns & that based delete all extra rows above till heading

    Hi, Chirag R Raval! This thread only goes by post #10. Regards!
  6. SirJB7

    Get Dates and No.s from String - any format and multiple dates

    Hi, prasaddn! No way of doing it without all pattern masks previously defined. Regards!
  7. SirJB7

    Unique List of Names and Count Type of Project

    Hi, Chihiro! AFAIK this is true from Excel versions 2010+, but for older ones -2007 in particular, which is still highly deployed- it is strongly recommended. VBA garbage collector uses a reference count that automatically destroys objects when it reaches zero. From 2010 in advance it's...
  8. SirJB7

    Unique List of Names and Count Type of Project

    Hi, DangerMan88! Give a look at the uploaded file. This is the involved code: Option Explicit Sub RollingSetback() ' ' constants Const ksWSInput = "Kaizen Log" Const ksTeamMembersInput = "TeamMembersTable" Const ksTypeInput = "TypeList" Const ksMembersInput =...
  9. SirJB7

    Change cell property (formula or VBA)

    Hi, Belleke! Give a try to this code: Option Explicit Sub X() Debug.Print sCarlsbergFunction("123456789A024321") End Sub Function sCarlsbergFunction(psInput As String) As String '123456789A024321 into 1234.56.789.A02.4321. ' constants Const ksPos = ",4,2,3,3,4" '...
  10. SirJB7

    countif changes the range

    Hi, jb! It's right that COUNTIF's range could get changed, since you'd be moving boundary cells of that range. But in the uploaded file you used ranges from row 3 to 7 and if you're changing row 2 formulas related to 3:7 won't get changed, of course. Regards!
  11. SirJB7

    Find a column based on a value in a header row and copy/paste to the adjacent cells

    Hi, ! Welcome to Chandoo forums! Checked this yet? http://chandoo.org/forum/forums/new-users-please-start-here.14/ About your question, have you tried the built-in feature for recording macros? This question it's very likely to be suitable for this approach method, which is feasible for novice...
  12. SirJB7

    Additions and Deletions

    Hi, Cody! Welcome to Chandoo forums! Checked this yet? http://chandoo.org/forum/forums/new-users-please-start-here.14/ About your question, consider uploading a sample file. It'd be easier to understand for people who might be able to help you. Include indication of the input data, the...
  13. SirJB7

    Listbox Multiselect Drag & Drop in Excel

    Hi, Krishna Khemraj! Does this help? https://stackoverflow.com/questions/38145421/vba-listbox-drag-drop Regards!
  14. SirJB7

    Age calculation formula

    Hi, Eloise T! I think your glasses are needing an urgent upgrade. You read this: and missed this, which was just following: BTW, nice Spanish :) Regards!
  15. SirJB7

    Age calculation formula

    Hi, Eloise T! I always post formulas in local and English languages. Regards!
Top