Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    9
    Views
    78

    Maudibe's first routine uncovered a few multiples...

    Maudibe's first routine uncovered a few multiples which I didn't think existed. GREAT to learn that. Bad data from the client, obviously. I'll try the 2nd also. I like them both...thanks again,...
  2. Replies
    9
    Views
    78

    GREAT for 239 rows, then I ended up interrupting...

    GREAT for 239 rows, then I ended up interrupting the macro after about 4 minutes of additional results. Was I too impatient?
    My AC column has 683 rows in it (incl header row 1). The current...
  3. Replies
    9
    Views
    78

    Maudibe almost has what I need. The specifics...

    Maudibe almost has what I need. The specifics are: In column AC (starting in row 2; row 1 has column header) I have text strings (they're all the same length, but I suspect that doesn't matter). ...
  4. Replies
    9
    Views
    78

    Find text string in an ARRAY of cells

    I have a text string in, say, A1. I want to look at,say, B1:G500 and find out the cell address where A1 is found in that array.
    I've been fooling around with array formula variations of match,...
  5. Replies
    1
    Views
    61

    Add-Ins strange behavior

    I have two add-ins installed (Excel 2010). When I look at File|Options|Add-Ins|Manage Excel Add-Ins they are checked.
    However they don't appear for use.

    If I uncheck them, leave the add-ins...
  6. Thread: solve for T

    by kweaver
    Replies
    7
    Views
    132

    Well, well, well! And, they're floating a log...

    Well, well, well! And, they're floating a log down stream!
  7. Thread: solve for T

    by kweaver
    Replies
    7
    Views
    132

    jepalmer: I didn't get it totally solved for...

    jepalmer:

    I didn't get it totally solved for T, but ...

    Also, this reference might help if you can contact the authors as they indicate they programmed this to solve for T.
    Maybe they can...
  8. [SOLVED] VBA Project not showing Visible, etc. oiptions

    In the VBA Project, I have a number of sheets that were hidden and some very hidden.
    I need to make some adjustments to a few of them. But, when I go into the VBA project, I no longer see those...
  9. Replies
    7
    Views
    295

    Watched fireworks from 3 barges in the bay from...

    Watched fireworks from 3 barges in the bay from friend's 17th floor apartment. Spectacular. Happy week for all!
  10. [SOLVED] That's perfect and I understand what you did is...

    That's perfect and I understand what you did is even better! Thanks, RG...regards to the boss.
  11. [SOLVED] I ended up with all the comment fields still...

    I ended up with all the comment fields still showing in the finished file.

    The line needs to be edited and all of the comment fields removed.

    This works: sLine = Left(sLine, 35) but I cannot...
  12. [SOLVED] It should ignore all of the "comment fields" and...

    It should ignore all of the "comment fields" and just return the other data fields.

    Users sometimes separate "comment fields" with one or more commas and they should all be ignored and only the...
  13. [SOLVED] RG...thanks for that...so, what should I do? ...

    RG...thanks for that...so, what should I do? Check for >=6 ? I tried that and it didn't solve the problem.
  14. [SOLVED] VBA code drops total line of TXT file. URGENT help needed if possible.

    [my VBA is not very good]

    I just got an Excel file with the code shown below. The initial TXT file on which is acts contains lines with fields separated by commas.
    So, two sample lines might...
  15. Replies
    3
    Views
    81

    Is there only 1 multi-digit number after the...

    Is there only 1 multi-digit number after the name?

    One array formula (CTRL+Shift+Enter): =--MID(A1,MATCH(TRUE,ISNUMBER(1*MID(A1,ROW($1:$101),1)),0),COUNT(1*MID(A1,ROW($1:$101),1)))

    I threw...
  16. Replies
    0
    Views
    59

    Select and copy all MERGEFIELD codes

    I have several legal documents that have a variety of MERGEFIELD codes throughout.
    The law firm is modifying their database references.
    I need a way to select all of the merge fields in a document...
  17. Replies
    12
    Views
    222

    ZEDDY: why have you been in the hospital for 15...

    ZEDDY: why have you been in the hospital for 15 days???
  18. Replies
    10
    Views
    203

    Very interesting, RG. Thanks for the effort. So...

    Very interesting, RG. Thanks for the effort. So far, testing seems fine. YAY!

    Have a great weekend in SC.
  19. Replies
    10
    Views
    203

    Absolutely, would LOVE to continue seeing your...

    Absolutely, would LOVE to continue seeing your skills on display! [as would others, I'm sure]
  20. Replies
    10
    Views
    203

    I understand, RG...thanks! I think this will...

    I understand, RG...thanks!

    I think this will become more work for the teacher(s) than it's worth. The courses (worksheets) each have a separate password to un-protect them and only the department...
  21. Replies
    10
    Views
    203

    I think I know what I need but can't write it. ...

    I think I know what I need but can't write it.

    A macro that would contain a list of sheets to be sorted, all the same range.

    It sounds like a CASE statement, but I cannot for the life of me...
  22. Replies
    10
    Views
    203

    Initially, from your workbook, that looks good. ...

    Initially, from your workbook, that looks good. But when I put grades in the 2nd sheet, then sorted the MASTER, they didn't follow the right person.

    In my MASTER sheet, I have a sequential series...
  23. Replies
    10
    Views
    203

    Sorting question/issue

    I'm working on a grade book application for a teacher friend of mine.
    On a "master student" sheet are the names of the students at the beginning of the semester.
    They are alphabetical by last name....
  24. Replies
    0
    Views
    58

    Calendar dropdown doesn't appear

    What in the world am I doing incorrectly? I've tried to install a date picker calendar into a cell.
    I've used the Developer tab, Insert the Microsoft Date & Time Picker, etc., and only get a date in...
  25. I only want the source cells to change color. ...

    I only want the source cells to change color. Maud's version changes both the source and destination cells. The user copies a block of cells, pastes them into another workbook, then returns to the...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4