Search:

Type: Posts; User: bobkap

Search: Search took 0.00 seconds.

  1. Replies
    1
    Views
    996

    Find text and replace

    As part of an Excel macro, I'm trying to find if a string has a specific word in it and then, if it does, copy the string to another cell without some of the words in the cell.

    I've tried this...
  2. Replies
    0
    Views
    1,163

    Set Length of Worksheet Name

    In my macro, what code would I need to have to have my worksheet name be 6 characters long? (Or any set number of characters for that matter.)

    I also posted this on mrexcel.com with this link:
    ...
  3. Replies
    5
    Views
    4,483

    YES Thanks so much for taking the time to help...

    YES

    Thanks so much for taking the time to help me with this. I hope I'm not violating any rules of your forum, but here are some more examples of my actual data:

    BLS Skills Check -- 8:00am to...
  4. Replies
    5
    Views
    4,483

    Sorry. I was trying to be as brief as possible. ...

    Sorry. I was trying to be as brief as possible. Here are some samples of what my data looks like:
    Heartsaver CPR and First Aid Course April 13th, 2013 [example without hyphen]
    BLS Certification...
  5. Replies
    5
    Views
    4,483

    Extract Certain Characters From A Text String

    I have a column of data with characters to both the left and right of a hyphen. I only want to read the information to the left of the hyphen. Yes, I could separate with text-to-columns but I don't...
  6. I hope I am not violating one of your site rules...

    I hope I am not violating one of your site rules by sending this message, but thanks VERY much. It works beautifully now!!!
  7. Error Handling When Range Is Not Defined Properly

    I have a macro with a vlookup statement and I know that from time to time the macro is going to bomb because I know that my users will not always correctly update the range the lookup statement...
  8. Replies
    3
    Views
    1,386

    Event target range

    I have a spreadsheet setup to run a macro every time there is a change in the worksheet. BUT, I only want this macro to be run automatically if a specific range of cells are changed. I am guessing...
Results 1 to 8 of 8