$$Excel-Macros$$ Parsing Text in a cell with VBA

2017-03-30 Thread Greg Della-Croce
I have a need for suggestion on a VBA that I want to create I have a series of cells (A1:A200), each cell contains: a blank, or a string of phrases (like: I don't like this, Things could be better, Use Word, Excel, but never Notes, ...) I need to parse the content of the cell and fill columns

$$Excel-Macros$$ Why can I not change the width or length of a table?

2017-02-22 Thread Greg Della-Croce
This may not be the right place to post this question, however, you have been great at helping me recently and I really appreciate it. I have a data table in an Excel sheet. I imported 106 records into columns A - G. I then highlighted them and created a table using the icon that shows up at

Re: $$Excel-Macros$$ Counting up the combinations

2017-02-20 Thread Greg Della-Croce
OK, people, I like a good dialog as much as anyone else. But will you please stop using this thread for your conversation! Thanks, Greg Della-Croce -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum

Re: $$Excel-Macros$$ Counting up the combinations

2017-02-20 Thread Greg Della-Croce
Paul, That is an excellent idea! All my survey results are on one page of on workbook. So this should be fairly simple to write. Thanks!! Greg Della-Croce Skype: gdellacroce55 Cell: 407-408-2572 greg_della-cr...@sil.org "If you assume you know the answer, you will miss having a breakth

$$Excel-Macros$$ Counting up the combinations

2017-02-18 Thread Greg Della-Croce
I have a sheet of responses to a short survey. The survey asked 4 questions with range answers (1 to 5, 5 being best), and then two open-ended questions. I would like to count up the number of each combination of answers with the range answers. So for all of the surveys, I would like to

Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE

2017-01-27 Thread Greg Della-Croce
, vbTextCompare) the function worked. Greg Della-Croce Skype: gdellacroce55 Cell: 407-408-2572 greg_della-cr...@sil.org "If you assume you know the answer, you will miss having a breakthrough. It’s okay to do what you did yesterday, but it will never be amazing again.". - *Rod Fa

Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE

2017-01-26 Thread Greg Della-Croce
Vicky, thanks for the idea. I will see how it works for me. I appreciate the time/effort you put in to help me! Greg Greg Della-Croce Skype: gdellacroce55 Cell: 407-408-2572 greg_della-cr...@sil.org "If you assume you know the answer, you will miss having a breakthrough. It’s okay to do

$$Excel-Macros$$ Simple function but it returns #VALUE

2017-01-19 Thread Greg Della-Croce
I am trying to create a very simple function that will take a string of text and read a range of texts to see if I have any that string in any of the ranges of the texts. Should be a 10-minute problem to solve. I am however getting a #VALUE back. I call the function with this:

$$Excel-Macros$$ Failure of a new Function

2016-10-21 Thread Greg Della-Croce
I have what I hope is a very simple question about why my new function is not working. I rarely create UDF so I suspect that I have done something wrong in the setup. I am using Excel 2013 on a PC. I have a spreadsheet Row A:1-9 has values for weighting results (1-10) Row B:1-9 has the

Re: $$Excel-Macros$$ How to do a summary of a large table

2015-10-13 Thread Greg Della-Croce
you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > -- > *From:* Greg Della-Croce <greg_del...@sil.org > > *To:* MS EXCEL AND VBA MACROS <ex

$$Excel-Macros$$ How to do a summary of a large table

2015-10-10 Thread Greg Della-Croce
Since I do no see a way to do this with just functions, I think I am going to have to write some code to do this myself, but I would appreciate a word from the experts (aka you people) I have a table with just shy of 50,000 rows that looks something like this: Key1 Key2 MinDate

$$Excel-Macros$$ Re: Novice question: Why will new Functions not show up in my 2013 Workbook?

2015-10-03 Thread Greg Della-Croce
Never mind found my error. Must be in a Module not Sheet2. My bad. GregDC On Friday, October 2, 2015 at 5:09:03 PM UTC-4, Greg Della-Croce wrote: > > OK, I know that this is a very simple error on my part. I put the > Function code in the Sheet2 General of the Project. I save th

$$Excel-Macros$$ Novice question: Why will new Functions not show up in my 2013 Workbook?

2015-10-02 Thread Greg Della-Croce
OK, I know that this is a very simple error on my part. I put the Function code in the Sheet2 General of the Project. I save the file, I save the spreadsheet. I go to use it in a cell and it does not show up on the function list. Yes I saved it as .xlsm, and Yes I enabled content. When I