Search:

Type: Posts; User: snb

Page 1 of 14 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    2
    Views
    3,235

    Sub M_snb() sn = Split("_" &...

    Sub M_snb()
    sn = Split("_" & Join([transpose(B6:B106)], "|_"), "|")
    ReDim sp(UBound(sn), 26)

    For j = 65 To 90
    st = Filter(sn, "_" & Chr(j))
    For jj = 0 To UBound(st)
    ...
  2. Replies
    17
    Views
    3,831

    I'd use: Sub M_snb() sn =...

    I'd use:


    Sub M_snb()
    sn = Sheet1.Cells(1).CurrentRegion

    c01 = "1"
    For j = 2 To UBound(sn)
    sn(j, 3) = Replace(sn(j, 3), ",", ";")
    For Each it In...
  3. If you could install Excel 2010 you were also...

    If you could install Excel 2010 you were also able to install Outlook.

    For other methods see: http://www.snb-vba.eu/VBA_Excelgegevens_mailen_en.html
  4. @Doc: See...

    @Doc:

    See http://www.snb-vba.eu/VBA_Outlook_external_en.html#L_4.1
  5. the tiniest 'micro': hire a profi. ...

    the tiniest 'micro': hire a profi.



    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
  6. I don't like exclamation marks. ...

    I don't like exclamation marks.



    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgyG714V_k7odQMrTz14AaABAg.9h740K6COOA9iHOYYpaAbC...
  7. Thread: Time Counter

    by snb
    Replies
    10
    Views
    2,438

    Weekday is a regular VBA-function instead of ...

    Weekday is a regular VBA-function

    instead of

    If Application.WorksheetFunction.Weekday(DTPicker1, 2) = 5 Then

    use

    If Weekday(DTPicker1, 2) = 5 Then
  8. Don't split data into separate worksheets. Use...

    Don't split data into separate worksheets.
    Use an intelligent table and a pivottable instead.
  9. =TEXT(RIGHT("00"&A2;8);"00\/00\/0000")

    =TEXT(RIGHT("00"&A2;8);"00\/00\/0000")
  10. http://www.snb-vba.eu/VBA_Dictionary_en.html...

    http://www.snb-vba.eu/VBA_Dictionary_en.html
    http://www.snb-vba.eu/VBA_Arrays_en.html
    http://www.snb-vba.eu/VBA_Collection_en.html
    http://www.snb-vba.eu/VBA_Arraylist_en.html...
  11. In that case you better shouldn't use Excel at...

    In that case you better shouldn't use Excel at all.
  12. See your other thread:...

    See your other thread: http://www.excelfox.com/forum/showthread.php/2198-How-can-you-convert-this-VBA-with-use-Scripting-Dictionary-so-it-becomes-fast?p=10334&viewfull=1#post10334
  13. Are you familiar with pivottables ?

    Are you familiar with pivottables ?
  14. Replies
    4
    Views
    1,448

    A querytable can be created without VBA.

    A querytable can be created without VBA.
  15. Replies
    4
    Views
    1,448

    What did you try ?

    What did you try ?
  16. Replies
    2
    Views
    1,144

    In that case you have 5 variables in combinations...

    In that case you have 5 variables in combinations of 4 elements.



    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA...
  17. You wrote: I would appreciate any assistance,...

    You wrote:

    I would appreciate any assistance, I'm not an export, but can f................
  18. I prefer import. :)

    I prefer import. :)
  19. Replies
    8
    Views
    1,941

    or Sub M_snb() sn=cells(1).currentregion...

    or


    Sub M_snb()
    sn=cells(1).currentregion

    for j=2 to ubound(sn)
    sn(j,1)=sn(j-1,1)
    sn((j,2)=sn(j-1,2) & " " & sn(j,2)
    sn((j-1,1)=""
  20. Sub M_snb() ActiveSheet.Name = "snb " &...

    Sub M_snb()
    ActiveSheet.Name = "snb " & Format(Application.Min(Columns(3)), "yy-") & Format(Application.Max(Columns(3)), "yy")
    End Sub
  21. In that case I'd use VBA: ...

    In that case I'd use VBA:


    [A1:A20]=[A1:A20/100]
  22. try percentage

    try percentage
  23. Replies
    4
    Views
    1,695

    If it's urgent, if it's crucial don't rely on a...

    If it's urgent, if it's crucial don't rely on a forum of volunteers: act professionally.
  24. Replies
    4
    Views
    1,695

    In that case: hire a software firm,.

    In that case: hire a software firm,.
  25. Replies
    14
    Views
    37,650

    Nur Paulaner:)

    Nur Paulaner:)
Results 1 to 25 of 337
Page 1 of 14 1 2 3 4