Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mohamadmh

    Improve speed of For i Loop ? Is is possible to use arrays

    Thanks SkipVought and understand. Appreciate you posting reply.
  2. mohamadmh

    Improve speed of For i Loop ? Is is possible to use arrays

    thank you again combo, but not an expert and would struggle to complete. Thank you again for your help
  3. mohamadmh

    Improve speed of For i Loop ? Is is possible to use arrays

    Thank you combo for the suggestions. Could you help modify the code?
  4. mohamadmh

    Improve speed of For i Loop ? Is is possible to use arrays

    H
  5. mohamadmh

    Find Position Number of word in string

    Found a solution. Sharing in case someone else needs similar function. Function wordPosition(sentence As String, searchWord As String) As Long Dim words As Variant Dim i As Long words = Split(sentence, ",") For i = LBound(words, 1) To UBound(words, 1) If words(i) =...
  6. mohamadmh

    Find Position Number of word in string

    Hi all, Thank you in advance for your help. In cell A2 I have: Field3,Field8,Field9,Field10 In cell B2 I would like to get: 2 (the position of the 2 word Field8 in string) I tried using InStr in UDF In cell B2 I am using below function: FindWordPosition(A2,"Field8") result of function in...
  7. mohamadmh

    Find and Replace Array UDF issue

    Thanks everyone this is very helpful
  8. mohamadmh

    Find and Replace Array UDF issue

    Thank you Andy! It works great. Appreciate your help!
  9. mohamadmh

    Find and Replace Array UDF issue

    Hi Andy, Understood, apologies for not following. Yes, ""ID ,Type, ISIN" is a part of your UDF and will ALWAYS be a part of your outcome if in Cell A1 contains one of these items "Field 3, Field 4, Field 8, Field 9, Field 10
  10. mohamadmh

    Find and Replace Array UDF issue

    Hi Andy, i am using the following UDF, but it is not replacing all values only one Function Replace3(expression As String) As String Dim strWhat As String, strRep As String Dim arrWhat As Variant, arrRep As Variant Dim i As Long On Error GoTo Replace3_Error strWhat =...
  11. mohamadmh

    Find and Replace Array UDF issue

    Hi Andy, Thank you for your response. Apologies for not being clear: In Cell A1 I Have: Field 3, Field 4, Field 8, Field 9, Field 10 In Cell B1 I would like to get: ID, Type, ISIN, Date, Field 10 I want to only replace a subset of fields in cell not all. Hope that is clearer. Thank you in...
  12. mohamadmh

    Find and Replace Array UDF issue

    Hi all, Thank you in advance for your help. I am working on a function in cell B to find and replace text in cell A. I still need cell A is a field I and cell B is a classification of that ID. The UDF I have only replace 1 (the last string in example below Date) of the three strings I want...
  13. mohamadmh

    Loop through column a tricky one

    Hi all, Thank you for your feedback. Apologies I was not very specific. I need help with writing the VBA code. Thank you again for your input and feedback.
  14. mohamadmh

    Loop through column a tricky one

    Hi All, Stuck on this issue. Still learning VBA. Would really appreciate any help.
  15. mohamadmh

    Loop through column a tricky one

    Thnks for your input combo. Def need help with the code.
  16. mohamadmh

    Loop through column a tricky one

    typo - Field 3 = XYZA
  17. mohamadmh

    Loop through column a tricky one

    Hi Skip and Combo, Thank you both for your replies. Combo you are correct in your logic. I am not that technically savvy yet to use array of words. Would need your help with the VBA code. Any suggestions would be greatly appreciated. Skip - for example: The value for this field 3, field 8...
  18. mohamadmh

    Loop through column a tricky one

    Hi Deniall, Apologies, File attchedhttps://files.engineering.com/getfile.aspx?folder=4b125e43-2bff-47fa-854d-14af6fd0ec61&file=Sample.xlsx
  19. mohamadmh

    Loop through column a tricky one

    Hi all, Struggling to find solution for this one. I need to loop through rows in column A and populate columns B1:Nth1 with text = field & # from row. Then populate values in column B2:Nth# from values in based on values in sting in column A. See attached example. Items in yellow are derived...

Part and Inventory Search

Back
Top