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

    Formula lock

    Hi Monty I went and checked again and this is what I found.
  2. C

    Formula lock

    Hi Monty As per the attached the Ref selection is grayed out. Please advice.
  3. C

    Formula lock

    Thank you very much Monty. I really appreciate it, but it is giving me an error as per the attached.
  4. C

    Formula lock

    .....thank you for your friendliness. Just leave it, I will make another plan. God bless.
  5. C

    Formula lock

    Hi I was referring to the protection of formulas in a workbook.
  6. C

    Formula lock

    Good day everyone Can you please assist by providing a macro to lock and hide all formulas in a workbook (all sheets). Must still be able to use the external link updates. Thank you very much in advance Best regards Jan
  7. C

    Copy rows based on a criteria

    h Hi Thank you very much for your assistance. Based on your feedback I have managed to do a workaround with the desired results. Regards Jan
  8. C

    Copy rows based on a criteria

  9. C

    Copy rows based on a criteria

    Hi Narayan Sorry about that. Here is the macro. Sub ReorgData() Dim LR As Long, a As Long, SR As Long, ER As Long Application.ScreenUpdating = False Rows(1).Insert Range("A1") = "TitleA" LR = Range("A" & Rows.Count).End(xlUp).Row Range("A2:B" & LR).Sort Key1:=Range("A2")...
  10. C

    Copy rows based on a criteria

    Hi Guy's. My name is Jan and I need your assistance please. I have a file with a macro that is giving me a "run-time error 13" notification. Your assistance will be highly appreciated. Thanks Jan
  11. C

    Code Generator

    Hi Guys Need your assistance please. Need a code generator that will be using 0,1,2,3,4,5,6,7,8,9 A,B,C,D,E,F to generate a four digit code when a four digit code is supplied. This will not be a random code generated , it will be specific. As at this stage all the codes are not yet known the...
Back
Top