1. C

    Help with Loop Without Do Error

    Hi guys, I've been trying to fix this VBA code (that a previous employee left us), but since I have no experience in VBA, I can't seem to figure it out. Would anyone of y'all be able to help me out? Sub categorization3a() Application.ScreenUpdating = False 'further segment PRODUCT row =...
  2. V

    Compilation error : BLOCK IF WITHOUT END IF

    If ((char = ",") And (cou >= 10)) Then add = add + char + vbNewLine c = 1 cou = 0 Else add = add + char c = 0...
  3. F

    Update existing hyperlinks automatically when changing the folder name linked documents are saved under

    Dear Forum members,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I am desperately looking for some advice from you Excel experts!<o:p></o:p> At work we are using an excel spreadsheet as a project checklist during the project execution phase...
  4. S

    disabling the info / warning messages!!!

    hi, pls help me disabling the prompt msg that encounter during the macro is running for eg - sheet is protected etc. secondly I wanted to know if i am asking user to input a no. in a input box but if the user presses cancel button insead of pressing ok then their should not be any error. it...

Some videos you may like

This Week's Hot Topics