Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.00 seconds.

  1. Re: Count cells but omit ones with certain text

    =COUNTIF(A1:A7,"<>Blue")
    ?
  2. Re: MsgBox when a certain percentage is reached

    Instead of trick with button transfer use COUNT formula on SheetB, then into code of SheetB use event Worksheet_Calculate() where you can check values and if >100% gives you msgbox.
    Or if you don't...
  3. Replies
    6
    Views
    70

    Re: Email BODY error lines all in red

    Happy to help.
  4. Replies
    6
    Views
    70

    Re: Email BODY error lines all in red

    .htmlBody so you can format text in email like html. So any additional breakline is &lt;br&gt;
  5. Replies
    6
    Views
    70

    Re: Email BODY error lines all in red

    Try like this:


    Private Sub CommandButton3_Click()

    Dim aOutlook As Object
    Dim aEmail As Object
    Dim rngeAddresses As Range, rngeCell As Range, strRecipients As String
    Set aOutlook =...
  6. Re: Return column of far most right value in a row

    @Aladin - it was not question about value from far most right column. It was a question about far most right column.
  7. Re: Return column of far most right value in a row

    Sure but OP definitely declared range A-Z :nya:
  8. Re: Return column of far most right value in a row

    If numbers:

    =LEFT(ADDRESS(1,MATCH(10^9,A1:Z1,1),4,1),1)

    if text:

    =LEFT(ADDRESS(1,MATCH("ZZZZZZZ",A1:Z1,1),4,1),1)
  9. Replies
    5
    Views
    228

    Re: VBA and Hidden Columns

    as 1. Take function MailWithFile outside Send_Notification sub.
    as 2. use indents like below:


    Set Rng = ActiveCell
    .Select
    ActiveWorkbook.EnvelopeVisible = True
    With...
  10. Re: Using vba to go to column with current week

    Please use CODE tag around vba code. Now it's hard to read really.
  11. Replies
    5
    Views
    228

    Re: VBA and Hidden Columns

    You would need to control Outlook directly instead of using the MailEnvelope method.
    Try this (of course need to be tweak a bit to your needs):


    Function MailWithFile(FileName As String, StrTo...
  12. Replies
    5
    Views
    228

    Re: VBA and Hidden Columns

    With .Item

    .SentOnBehalfOfName = "emailaddresshere"
    .To = EmailAddr
    .CC = "emailaddresshere"
    .BCC = ""
    .Subject = "E-mail"
    .Display

    End With
  13. Re: Find 2nd and 3rd highest numbers in a row and return column header

    A
    B
    C
    D
    E
    F

    1ETF-AETF-BETF-CETF-D
    27ETF-B
  14. Re: Find 2nd and 3rd highest numbers in a row and return column header

    It is your case but to be honest in my opinion if should be:
    1st ETF-B
    2nd ETF-C, ETF-D
    3rd ETF-A

    as ETF-C and D has the same value.
  15. Re: Find 2nd and 3rd highest numbers in a row and return column header

    ETF-D is not 3rd is also 2nd...
  16. Replies
    36
    Views
    845

    Re: Check if a cell contains same digits

    You did not mention about VBA in original post or thread title?

    Into sheet code:


    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    MsgBox Evaluate("=SUM(CODE(MID(" &...
  17. Re: Find 2nd and 3rd highest numbers in a row and return column header

    In this case (if 2nd value appeared twice) do you want to display both headers? Like ETF-C, ETF-D?
  18. Replies
    8
    Views
    129

    Re: Slightly tricky conditional formatting

    If you wants to 'recopy' color of cell which is results of Conditional Formatting is not a way.
    It could works (not tested) for hardcoded color.
  19. Replies
    36
    Views
    845

    Re: Check if a cell contains same digits

    Probably there is lots for solution, I've got something like this:

    <tbody>


    A


    B
  20. Replies
    2
    Views
    111

    Re: Problem deleting rows in VB

    Hi
    Try like this:


    For i = lastRow To IRStartCell Step -1
    K = Cells(i, 18).Value
    If Not K Like "DUB*" And Not K Like "LMK*" And Not K Like "ORK*" Then
    Rows(i).EntireRow.Delete...
  21. Replies
    1
    Views
    178

    Re: Use VBA to add code to sheet as inserted

    Cross post, solved there https://www.excelforum.com/excel-programming-vba-macros/1286687-add-code-automatically-to-a-sheet-as-it-is-inserted.html
  22. Replies
    29
    Views
    764

    Re: Sum in selected cell

    Put into sheet code:



    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Not Intersect(Target, [A1:A10]) Is Nothing Then 'set range as You need
    Target.Value =...
  23. Replies
    5
    Views
    255

    Re: Hide Check Box base on another cells data

    You have written:

    I have a cell K14 that has a list of 3 options:
    so I expect that in K14 is dropdown list.
  24. Replies
    8
    Views
    295

    Re: Getting spreadsheet to someone without XL

    Save as single web page mht/mhtml?
  25. Re: VBA for excel to send multiple emails; subject; body (Content)

    .Subject = Range("B" & i).Value
    .To = Range("A" & i).Value
    .Body = Range("C" & i).Value
Results 1 to 25 of 80
Page 1 of 4 1 2 3 4