Search:

Type: Posts; User: dguillett@gmail.com; Keyword(s):

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds; generated 3 minute(s) ago.

  1. WLM Windows Live Mail Duplicates Prevent and remove existing GMAIL

    As the subject says., I have duplicates created in my inbox that I want to prevent and delete the existing. Assistance appreciated

    I have 3 Gmail accounts that I read in WLM
  2. http://www.ibm.com/us/en/ use this...

    http://www.ibm.com/us/en/
    use this
    =IF(ISERROR(FIND("//www.",J3)), MID(J3,FIND(":",J3,4)+3,FIND("/",J3,9)-FIND(":",J3,4)-3), MID(J3,FIND(":",J3,4)+7,FIND("/",J3,9)-FIND(":",J3,4)-7))
    to get...
  3. convert formulas that are no longer needed to...

    convert formulas that are no longer needed to values
  4. Replies
    7
    Views
    290

    To do an entire range using the function Sub...

    To do an entire range using the function

    Sub fixphonerange()
    Dim c As Range
    Dim num As Range
    For Each c In Range("E1:e15")
    c = pn(c)
    Next
    End Sub
  5. Replies
    7
    Views
    290

    Try this instead Function pn(Num) As String Dim...

    Try this instead
    Function pn(Num) As String
    Dim i As Integer
    For i = 1 To Len(Num)
    If Asc(Mid(Num, i, 1)) >= Asc("0") _
    And Asc(Mid(Num, i, 1)) <= Asc("9") Then
    pn = pn + Mid(Num,...
  6. Goto Ron's site>download the "merge" examples...

    Goto Ron's site>download the "merge" examples workbook>determine which to modify to your use>. You only learn by YOU doing instead of others doing it for you for free!!
  7. Replies
    2
    Views
    103

    You are opening 123 files (which version) in what...

    You are opening 123 files (which version) in what version_______ of _________________? If desired send the file directly to me. dguillett @gmail.com
  8. Look here...

    Look here
    http://www.rondebruin.nl/win/s3/win008.htm
    for
    Merge a range from all workbooks in a folder (below each other)
  9. Nicely done. Only comment is use native instr...

    Nicely done. Only comment is use native instr instead of application.find
    InStr(zRng, ztext)
  10. Although I am using my chase account to just park...

    Although I am using my chase account to just park some money due to a promotion and have NO negatives, I did download the csv> put in a - in front of and entry and ran this one liner to remove the -...
  11. Replies
    1
    Views
    101

    Here is a desktop shortcut I have to open a file...

    Here is a desktop shortcut I have to open a file with 2013 that doesn't do that
    target
    C:\Program Files (x86)\Microsoft Office 2010\Office15\EXCEL.EXE" "c:\personal\myfilenamehere.xls"
    startin...
  12. 'Could be better but works Option Explicit...

    'Could be better but works

    Option Explicit
    Sub LineEmUpSAS()
    Dim i As Long
    Application.ScreenUpdating = 0
    i = 1
    Do Until IsEmpty(Cells(i, 1))
    If Len(Application.Trim(Cells(i, 4))) <> 0 Then...
  13. Option Explicit Sub TransposeSAS() Dim c As...

    Option Explicit
    Sub TransposeSAS()
    Dim c As Integer
    Dim lc As Integer
    Dim i As Long

    With ActiveSheet
    .Columns.ClearContents
    For c = 1 To 3
    lc = Cells(1,...
  14. Replies
    7
    Views
    191

    And set wbdata= should not be necessary

    And set wbdata= should not be necessary
  15. To avoid leaving a formula or formula=value just...

    To avoid leaving a formula or formula=value just use
    Range("A" & Row & ":C" & Row).value=application.transpose(etc).value
  16. Thanks, I usually try to avoid all selections...

    Thanks, I usually try to avoid all selections and copy/pastes where possible
  17. Replies
    7
    Views
    191

    The error is not that. It will run with/without...

    The error is not that.
    It will run with/without the set wbData=
    It will run with/without the wbData=

    The problem is that the macro is asking for .xls files to open and the list has the...
  18. I always thought selections should be avoided...

    I always thought selections should be avoided where possible?

    'COPY DAY ROW TO BOTH SHEETS
    week.Range("B" & weekRow).Resize(, 50).Value = _
    day.Cells(51, 2).Resize(, 50).Value...
  19. Replies
    4
    Views
    222

    I stand corrected IF the header part was needed....

    I stand corrected IF the header part was needed. As I understood (not well explained) OP just wanted to get info from the file and not to make it pretty.
    We should always be trying to improve our...
  20. Replies
    4
    Views
    222

    If that is the need then this should be a bit...

    If that is the need then this should be a bit more efficient

    Option Explicit
    Sub UnmergeCellsSAS()
    Dim fr As Long
    Dim lr As Long
    Application.ScreenUpdating = 0...
  21. Replies
    9
    Views
    369

    provide sample FILE with before/after

    provide sample FILE with before/after
  22. Homework?

    Homework?
  23. IF you change the format of your v10:z10 from...

    IF you change the format of your v10:z10 from MERGE to CENTER ACROSS and use the formula, AS WRITTEN, and then apply the CSE it works just fine for the parameters given........
    See attached.
  24. Please tell us WHY it didn't work and what more...

    Please tell us WHY it didn't work and what more you expect it to do????? A larger sample might be good or the ACTUAL file.
  25. http://www.rondebruin.nl/win/s3/win026.htm

    http://www.rondebruin.nl/win/s3/win026.htm
Results 1 to 25 of 122
Page 1 of 5 1 2 3 4