Programming

Best Method
What is the best method to make a list of randomized(non-repeating) numbers between a start value and a end value? ... 19 Mar 2010 01:39

NCAA Bracket in Excel
James, I found your post while searching online. I made up brackets and pool manager files that I think will work for your needs. Feel free to download them via the links below. I know I'm late on alerting you to this, but I hope they work for in 2010. http://whenthewhistleblows.wordpress.com/2010/03/08/ncaa-baske... 14 Mar 2010 19:54

Need help with chart formatting
I need to deselect everything on a chart in a chart window in order to resize it to the screen. In Excel, the escape key does this but the VBA code "ActiveChart.Deselect" does not, even though the help screen says it is identical to the escape key. I can't find any way to deselect everything; the funky (and ev... 14 Mar 2010 17:41

Word wrap and height
Hello Currently, when I type data in a cell and go past the width of the cell it just keeps going into the adjacent cell. Is there a way to make the text wrap around and make the height for the cell allow the text to be visible. In other words wrap the text around to another line in the cell and have it readab... 14 Mar 2010 13:10

activesheet error
Hi I've done something wrong here and I can't work out what it is... Error msg: "Compile Error: With object must be user-defined type, object, or Variant" Sub copylplan() Dim mySheet As String mySheet = ActiveSheet With mySheet .Copy After:=Sheets(Sheets.Count) End With W... 14 Mar 2010 00:10

Marking found records in Workbook A from Target List in Workbook B
From Target List in Workbook B column A, (Activity ID), I need to yellow shade column A (Activity ID), in workbook A for any matching Activity ID's. .. Detail : Workbook B, has first to be cleaned up by deleting the first 5 rows and deleting any remaining rows that have empty cells in column A, through the last... 14 Mar 2010 03:19

Please assist. Extract Number from String
On 12/16/2009 11:39 AM, Damil4real wrote: How can I use a macro to extract only the first batch of numbers from the following type of info? Examples: 01458-MODE 1548-JUNE 1245-NOD 01054-MORNING 00154-JUNE 55145-55145 Result should be: 01458 1548 1245 01054 00154 ... 18 Mar 2010 11:43

Project Window does not refresh?
How come the Project Window retains the code on spreadsheets that I have already closed? The only way to refresh is to close msExcel. I maybe have altered something in the options. ... 13 Mar 2010 20:54

Novice question: I cannot get the immediate window to work
I am trying to learn VBA from a STEP BY STEP written by Reed Jacobson. He encourages using the Immediate Window because he claims you can see the progress as you code. I am copying his code verbatim. For example, in the current practice, I have the following Macro shell; Sub PivotSet Style() Dim pt as Pivotta... 14 Mar 2010 21:00

vba excel 2007 data mining
hi, i tried recording a macro to do an analysis using excel 2007 data mining addin. But later when i try to run the macro it did not work. I checked the macro code - it did not seem have any code to call the data mining algorithm in the data mining addin. Please help ... 13 Mar 2010 16:30