Search:

Type: Posts; User: harky; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: VBA: If Range Contains Cell Value Copy than del

    I had a code1 that copy the data from sheet1 to sheet2 at current Marco

    So I want it to run the code1 and than this one (code2) under on Marco.

    But it run together and mess up
  2. Re: VBA Macro: Find value in Column F and Replace

    It find

    "poster//"
    With
    "poster/"
  3. Re: VBA Macro: Find value in Column F and Replace

    Can't because there are thousand data.

    It find

    "poster//"
    With
    "poster/"
  4. Re: VBA: If Range Contains Cell Value Copy than del

    Hi Thanks.

    This code is what i want but...................

    i cant get it code works if i had another code...

    Sub Step4_Copy4Path()
  5. Re: VBA: If Range Contains Cell Value Copy than del

    This code is what i want but...................

    i cant get it code works if i had another code...





    Sub Step4_Copy4Path()
  6. VBA Macro: Find value in Column F and Replace

    I want to find "" in Column F and replace with ""

    :)
  7. Re: VBA: If Range Contains Cell Value Copy than del

    hi yes! thanks! work great.


    hmmm

    i can add a Set ws = Sheets("path")?
  8. Re: VBA: If Range Contains Cell Value Copy than del

    oh my.. should be


    If Col C cell contain 'Poster' OR 'Index' than
    Copy Col E 'value' to Col A Cell Than
    clearcontents Col E 'value' (delete the data), not row or column
  9. VBA: If Range Contains Cell Value Copy than del

    I need help :)


    If Col C cell contain 'Poster' OR 'Index' COPY TO
    Col E Cell to Col A Cell Than
    Delete Col E E

    the flow is

    *xxx refer to some text
  10. Replies
    9
    Views
    275

    Re: VBA: Replace X with X @ Col X

    Sorry should be



    If Col C is Poster, ClearContent Col E (not delete the row), just want to remove the text inside.
  11. Replies
    9
    Views
    275

    Re: VBA: Replace X with X @ Col X

    Thank you so much...
    eh

    i need one more help :D

    If Col C is Poster, Delete Col D & Col E (not delete the row), just want to remove the text inside.
  12. Re: Macro: Auto Fill down on Col A & B base on cell

    Thanks you so much!



    Thanks you so much!



    Thanks you so much!
  13. Macro: Auto Fill down on Col A & B base on cell

    The pic1 show original, and the marco will auto fill down as show in pic2 (yellow)


    https://i.imgur.com/1BepwE6.jpg



    https://i.imgur.com/jvwvJKM.jpg
  14. Re: Macro help: Transpose row to column & Copy, paste data

    Hi, I need some help again... sorry

    i added 2 more row, now the code dont work well


    https://i.imgur.com/bkBzeRt.gif

    https://i.imgur.com/RLZWPFP.jpg

    https://i.imgur.com/EFS8Dhz.jpg
  15. Replies
    9
    Views
    275

    Re: VBA: Replace X with X @ Col X

    Thanks! it work great
  16. Replies
    9
    Views
    275

    Re: VBA: Replace X with X @ Col X

    <tbody>
    Col F

    Col D (Result)
    Col E (Result)


    index
    if Col F is index, it will replace Col D to 16 & Col E to Index
    16
  17. Replies
    9
    Views
    275

    Re: VBA: Replace X with X @ Col X

    Hi this work great but

    How to check F2 also.. i got one more col to check.

    Check col F , F2 below
    and fill Col D

    Case "index": cel = "Index"
  18. Re: VBA to send emails attachment base on path (folder)

    If u read, it does what u want..

    attach 1 file or all file from the folder
  19. Re: Macro help: Transpose row to column & Copy, paste data

    ahh.. i manage to change it :D





    Dim Lst As Long, Lstcol As Long, n As Long
    Application.ScreenUpdating = False
    Lst = Range("A" & Rows.Count).End(xlUp).Row
    For n = Lst To 2 Step -1
  20. Re: Macro help: Transpose row to column & Copy, paste data

    hmm

    i add one more column.
    So now is not column E but F
    and start off at A4

    how to edit the code :)
  21. Replies
    4
    Views
    138

    Re: VBA: Copy X Col to new sheet

    Hi,
    I manage to get the code work myself :)





    Sub Step1_CopyRange()
    Dim lr As Long
  22. Replies
    4
    Views
    138

    Re: VBA: Copy X Col to new sheet

    hi,
    this isnt what i want.. i want to copy the WHOLE COLUMN. Start from B16 below

    ur code only copy 1 row?


    i want to copy COLUMN not row.
  23. Replies
    4
    Views
    138

    VBA: Copy X Col to new sheet

    I like to copy a marco to copy 'masterlist' sheet of X roll below

    HOPE somone can help me :)


    <tbody>
    B16
    C16
    E16
    H16
  24. Moving send email to ARCHIVE Folder once email sent.

    I had this code which work pretty well from this user here.
    https://www.mrexcel.com/forum/excel-questions/1103982-vba-send-emails-attachment-base-path-folder-4.html

    But need someone to help....
  25. Re: VBA to send emails attachment base on path (folder)

    Hi Thanks.

    I been using this script.

    Can i add one more function?

    In outlook, there is a SAVE SENT ITEM TO XX folder
    Can i save sent in my ARCHIVE Folder?

    Main: 2019_ARCHIVE
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4