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...
Type: Posts; User: bobkap
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...
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:
...
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...
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...
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...
I hope I am not violating one of your site rules by sending this message, but thanks VERY much. It works beautifully now!!!
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...
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...