General

Help with writing a macro to create a list
Hi! I've been trying to create a macro for a while but I'm not having much success. Hopefully you guys can help! I have a list of all the orders placed for our product on one tab called "Orders", with a customer number in column B. On a second tab "Clients", you'll be amazed to find out that I have a list ... 3 Feb 2010 10:35

pinewood derby
I would like to have a spreadsheet that once the user inputs the number of lanes and the individuals racing, a racing schedule would be produced. The goal of this schedule would have every car race against every other car (throughout the night) and race on every track approxiamately the same number of times... 3 Feb 2010 10:35

Excel 2003 autocomplete delay
I want excel to autocomplete information in a cell based on the minimum number of letters entered, but I am finding that in some cells I have to type in nearly all the way to the end before it 'anticipates' and fills in the cell. For example: In a column I want to type 'Continue Therapy', but I am getting t... 3 Feb 2010 09:28

Advanced filter criteria
I am using the AdvancedFilter technique to filter a large data set. Everything works fine. I am searching in a particular column for text matching the following pattern: ="=*TEXT*" and this works well. However, I need to use this filter to find records that contain double quote marks: " (the column conta... 4 Feb 2010 04:29

ODBC Driver Manager: Option type out of range
"TerryM" wrote: I used to successfully connect to Oracle databases with Microsoft ODBC driver for Oracle. In Office 2010 I now get the following error: Microsoft ODBC driver manager: option type out of range ... 3 Feb 2010 07:15

Excel Error Send AppVer: 12.0.6514.5000 AppStamp:4a89db07
every time when I open the excel sheet on the other PC, do what I have to do, save and close, and when I will on my PC to open excl sheet I become this error: AppName: excel.exe AppVer: 12.0.6514.5000 AppStamp:4a89db07 ModName: vbe6.dll ModVer: 6.5.10.24 ModStamp:464105f1 fDebug: 0 Off... 3 Feb 2010 05:04

Excel "forgetting" its add-ins
Hi Angry, It would be helpful if you could post; 1) What operating system you are using 2) What version of Office Ed Ferrero www.edferrero.com ... 3 Feb 2010 02:54

getting rid of a hidden column behind the front column
I created columns and rows; however, the 4th column has a column that I had created earlier but couldn't find so I created another one.....Now, I'm positive that I have one on top of the other......how can I see the one in the back so that I can get rid of it (delete it, etc.)?.....thank you so very much...... ... 2 Feb 2010 22:27

Hide Message Bar
I have a series of macros that modify data in a protected workbook. Only certain users have permission under SharePoint to run the macros and modify the data. At the end of the macro it displays a worksheet (read only) with the current edited data visible for all to see. But I also get a Message Bar(Excel 2007... 2 Feb 2010 22:27

fraction into date
hi all members... I have excel 2007 and when I enter a number like 6/33 it turns it into Jun-33. this number 6/33 is being copy from one note 2007 and pasted into excel. I have tried to manipulate it but to no success and have checked out 'excel options'. can someone please help. I thank all for your time and a... 27 Feb 2010 08:49