Posts by ShosMeister

    Re: Displaying Table based on Dropdown selection

    You need to provide a sample of the chart you are trying to get. It's a relatively simple matter to change the data source of the chart based on the value in the pull-down (more specifically when the pull-down is changed).

    Re: Running Two Loops Together VBA

    As long as your not talking threading then yes they can be done. It all depends on how you implement it. If you have something working and need help fixing it, you need to attach a sample indicating where the failure is and what your expectations are.

    Re: Create multiple charts using VBA

    Try this:

    The only item you'll have to add in is to clear the old charts before creating new ones if you use existing sheets. From what you said before though that you are creating the data sheet from another function, this shouldn't be necessary.

    Re: Delete rows based on criteria with a large data set

    I don't think it's ridiculous but understand your wanting it to be faster. One thing I can think of would be to use conditional formatting for all the cells (that could be done during import or in advance) and then searching for the format. So if the value in the cell is outside of the min/max values, change cell format to red or something. Then just look for any cell that is red and delete the entire row. Haven't tested, just a thought.

    The multiple column min/max you answered even though you didn't understand the question. I was trying to determine if each column was AND or OR with the other columns in that row. You answered by saying if any cell's value was outside of the min/max range for that column, the entire row is deleted. That makes the answer to my question an OR function. Again, the above idea may help speed it up.

    One other thing in your code you are comparing <= min but > max. Should they both be <= | => or just < | >?

    Re: Delete rows based on criteria with a large data set

    First off, 10 seconds isn't that long considering what it would take by hand.

    Second, the rule you didn't define is if the multiple column min/max are AND or OR.

    Third, if your import will always have a different number of columns, your "table" at the top will extend past row 25 and your code will fail. I'd suggest you create that "table" on a separate worksheet. You can still use the named references as long as they are workbook names and not just worksheet names.

    Other than that, looks like it works pretty well. You didn't indicate that it was broken, just slow so my only suggestion would be to sort the data by the column you are comparing and then change your look from looking at every row to a while loop. May make it go a bit faster but again, a lot faster than by hand.

    Re: Create multiple charts using VBA

    Is is coincidental that each "table" has 7 labels? If it's not and there will always be 7, then you can just create the charts once and have them update when you change the data.

    I'm guessing this isn't the case, so... You use "X" in your VBA to track where the data series is coming from. You initialize it at 12 but never increment it.

    Re: Creating Automatic Label creater spreadsheet

    You just put in the first one and then click and drag the lower corner of the cell and Excel will automatically increment the number. So entering A-01 into the first cell and click/drag down 29 cells, you'll end up with A-01 through A-30. Works with any combination of letters as Excel will always increment the last number sequence.

    If you don't know how, look up "Use the fill handle to fill data" in the help.

    Re: Office 2007 CreateItem(olMailItem) failing

    Sorry for omitting that code. It actually does what you did, just gets the object. Included here for completeness:

    Thanks for confirming the change of .Recipients to .To. Any ideas why though?

    Re: Office 2007 CreateItem(olMailItem) failing

    Still trying to resolve this issue - been working around by running on Office 2003 version workstation. I've seen some other e-mail related VBA and instead of using .Recipients.Add, they just use the .To= to set the recipients e-mail addresses. Have not been able to test yet, but, wanted to see if anyone else had any other ideas.