Programming

Simple... Using FIND, I need to get the row and cell
Using the FIND below, what do I need to get the row and cell where I find the match in column B? With Sheets("Sheet1").Range("B:B") Set Rng = .Find(What:="I-100421224950", _ After:=.Cells(.Cells.Count), _ LookIn:=xlValues, _ L... 22 Apr 2010 01:01

ActiveWorkbook.Save saves to wrong directory
ActiveWorkbook.Save creates a new spreadsheet in Documents instead of saving the spreadsheet in its current location. I am using Excel 2007 with a 2003 file (.xls). The macro is in personal.xlsb and is used to make a few minor fixes to the active spreadsheet. I want to save the active spreadsheet before I ma... 21 Apr 2010 20:53

Customized toolbar button trigger macro in a different file
That was no help! "JZ" wrote: I wrote a macro and assigned it to a button in myToolbar. My goal is to let people to create their file based on this one and click the button to run the macro. First I saved it as a xls file, then I copy/paste and rename to create a new one. After I open the ne... 21 Apr 2010 17:46

FormulaR1C1 using variables
I want to do this but can't: ActiveCell.FormulaR1C1 = "=MyFunction(R[variable]C[variable])" What are my options? ... 21 Apr 2010 19:51

Excel Convert text to Number
Hi, I need help on how to automate the conversion of a range of Excel cells from text to numbers. I'm using Excel 2007 to test, VB.NET 2005 and Excel 9.0 Object lib. I've read some rows of data into an array and I set my Excel Range = to the array which copies everything in quickly which is what I want. Cel... 21 Apr 2010 19:51

Pivot table has source data has exceeded 65536 records typemisma
Hi your problem is that you wrote the code under XL2002. You have obviously moved to XL2007 (xlsm file and 77,000 rows) Change TableName:="PivotTable1", DefaultVersion:=xlPivotTableVersion10 to TableName:="PivotTable1", DefaultVersion:=xlPivotTableVersion12 -- Regards Roger Govier Epidemic wrote: o... 21 Apr 2010 12:35

DSOFile.dll error - The document is not an OLE file
Hi - I'm getting the error "The document is not an OLE file, and does not support extended document properties" when I query the custom properties in an Excel 2007 using http://support.microsoft.com/default.aspx/kb/224351?p=1. The same VBA code works fine when I run on 32 bit versions of Windows 2003 and Windo... 28 Apr 2010 12:54

Recommendations
Can anyone recommend a good site that would be good to learn how to create reports in Excel. I have tried using the Pivot Table and it's not working for me. All I want to accomplish is to take the following information and generate reports from it. Date Name Request Received Start Time Finished Time ... 21 Apr 2010 13:37

Link error/Warning using macro in files converted to Excel 2007 (.
Problem: Receiving the following message during macro run "This workbook contains one or more links that can not be updated" with the continue or edit buttons. This only occurs for some files, which have no distinguishing characteristic differences to the non warning message files Background: Exce... 21 Apr 2010 11:33

Sheet Cleanup Help Please
I have a sheet that has formatting pre set for Columns A:BM. My data key will be row 1. I need to clear all data in all rows to the right of where row 1 data ends. Example: Col A Col B Col c Col D Col E Row 1 Data Data Data Data population ends in Cell C1, Clear all data D:BM. Col A Col B C... 21 Apr 2010 13:37