Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    5
    Views
    66

    Re: VBA equivalent of Worksheet Function

    Sorry for this

    "31 Feb"

    I was testing, obviously there is no such date.
  2. Replies
    5
    Views
    66

    Re: VBA equivalent of Worksheet Function

    It is no longer clear what you need.


    You asked for help to pass the formula to VBA.


    Then you asked for help to find the day and month.
    I give you the formulas to find the day and month of...
  3. Replies
    5
    Views
    66

    Re: VBA equivalent of Worksheet Function

    Welcome to the forum!

    Activate the macro recorder.
    Edit the formula and press enter.
    Stop the macro recorder.
    Check the macros and you will have something like this:



    Sub Macro6()
  4. Re: VBA Adding and removing conditional formatting

    The following occurred to me, just change the RGB color to the color number.



    Sub ChkBxA()
    Dim rg As Range, Chk As CheckBox, uv As UniqueValues, wcolor As Variant

    wcolor =...
  5. Re: Code Particular Strings As Numbers, Then Sum Numbers

    Another option

    <table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col...
  6. Replies
    10
    Views
    182

    Re: VBA A code within a loop

    I'm glad to help you. I appreciate your kind comments.
  7. Replies
    2
    Views
    87

    Re: Sumifs/Sumproduct

    The sumproduct option
    I guess the formula is on the "Reo" sheet
    ...
  8. Re: Did customer in one list buy an item in another list?

    In agreement
  9. Re: Create a separate worksheet for every unique name in Column A and copy data to each worksheet

    Try this



    Option Explicit
    Sub Create_separate_worksheet()
    Dim c As Range, sh As Worksheet, Ky As Variant

    Set sh = Sheets(1)
    With CreateObject("scripting.dictionary")
  10. Re: Did customer in one list buy an item in another list?

    I help you, but I need to know how your data is and the result you expect.


    Please Note
    -----------------------
    One thing you must keep in mind when you ask a question in a forum... the people...
  11. Re: Filter Sheet2 Data based on Sheet1 List Values

    I'm glad to help you. Thanks for the feedback.
  12. Replies
    10
    Views
    182

    Re: VBA A code within a loop

    Just change this by the desired number


    For n = 1 To 6
  13. Re: VBA Code to send email based on cell not working

    Thanks Domenic, I hope it works for the OP.
  14. Re: Excel Userform - Multiple Checkbox comments populate textbox upon clicking

    I'm glad to help you. Thanks for the feedback.
  15. Re: Filter Sheet2 Data based on Sheet1 List Values

    Ok, Let me know if you have any doubt.
  16. Re: Duplicate template based on refreshed list

    Just a couple of details, in the For cycle, you should put the sheet sh. only if you do not execute the macro from the sheet "Sheets Insert"


    Although it is not important, also the reference of...
  17. Re: Copy & Paste specific cell in VBA if cell contains any number will not copy and paste if blank.

    If we use the < o > signs, you must put a space before and after each sign, otherwise the forum editor considers it a code and then deletes the row.

    You could upload a copy of your file to a free...
  18. Replies
    1
    Views
    40

    Re: ListBox Item - Change text font

    You can change the font of all the data in the listbox:

    http://tedata.blob.core.windows.net/uploads/md/8648a40c3322f900d271c55ac0855be9.jpg

    In the forecolor property of the listbox.

    But you...
  19. Re: Did customer in one list buy an item in another list?

    Hi, to be more specific.
    You could put 3 sheets.
    One with the data from the customer sheet.
    Two with the data from the second sheet.
    And Three, with the expected result, explaining a couple of...
  20. Re: VBA Code to send email based on cell not working

    This event is activated when a cell is modified. In the case of the formulas, the cell is not modified, the formula remains the same, what changed was the result of the formula.


    Private Sub...
  21. Re: Button to Automatically Sort Column Values from Largest to Smallest

    Try this



    Sub Sort_All()
    ActiveSheet.UsedRange.Sort key1:=Range("A1"), order1:=xlDescending, Header:=xlYes
    End Sub
  22. Re: Auto Fill Customer Information Based on ID

    I'm glad to help you. Thanks for the feedback.
  23. Re: VBA to send emails attachment base on path (folder)

    I'm glad to help you. Thanks for the feedback.
  24. Re: VBA to send emails attachment base on path (folder)

    Try:



    Sub SendEmail()
    Dim i As Integer, Mail_Object, Email_Subject, o As Variant, lr As Long, d As Long
    Dim wks As Worksheet, pf As String, wPath As String, wFile As Variant, wPattern...
  25. Re: VBA to send emails attachment base on path (folder)

    What do you mean?
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4