Programming

command for save and close my page
hi all i need the vbe command for save and close the page can you help me ?? ty ... 18 Jul 2008 23:42

Warn if Cell/Column/Row Contains a Range Name
Is there a way to have a msgbox pop up whenever you are trying to delete a range that contains a range name? If so, can it also provide the affected cell address(es)? If not, is it possible to even get a warning after the fact that you just deleted a range name? ... 21 Jul 2008 11:00

Need to find a value in a range and take action if its there
OK I have 1 range that is constantly changing with different goalies info. This range has 3 columns, the first is the goalie number, the second is the goalie position (always the letter G) and the third is the goalie name. I have a second range that is a database of all goalies that have ever appeared in the fi... 18 Jul 2008 16:31

Excel Programming
Could anyone suggest a good book for learning to program in Excel? Macos etc. ... 18 Jul 2008 16:31

Replace microsoft forms message box with something more meaningful
Hi I have a userform with a combobox whos "match entry" property is set to True. If the user enters invalid text they get a microsoft forms message saying invalid property value. How do I change the message to something more meaningful. I would be grateful for any help Kenny W XP pro and Office 2003 ... 18 Jul 2008 16:31

Separating information in a text string
I have imported information from an AS400 into an Excel spreadsheet. I need to separate the employee name field. Currently the name field is "Brown, Oscar J". All names vary in length. What is the easiest way to split this into separate columns under Last Name, First Name, and Middle Initial? ... 19 Jul 2008 12:58

If, Then, Delete Entire Row, Loop, End
Hi, I appreciate your help. I need to run a conditional If Then statement on a defined table. If the cell in column 1 is blank or null, then delete the entire row, and run this statement on every row until the end of the table. Thanks again!, JC ... 18 Jul 2008 16:31

how to append and remove dups
hi! I have the following spreadsheet: columna columnb columnc columnd 1 AAAA BCBCBC xyxyxy 1 AAAA DEDEDE sdsdw 2 DDDDD ghjhedt jhughu 2 DD... 18 Jul 2008 16:31

Comparing two spreadsheets to analyze changes
I am needing to compare two spreadsheets - one for the previous month and one for the current month. I need to find the unique IDs that are new in the current month's file and also find those who had more than a $25000 difference from the previous file and so are on both files. ... 18 Jul 2008 16:31

Similar Cell Data Comparison?
Is there any function or add-on that can allow me to compare two cells and provide some type of similarity score? Would like to determine matches such as "John Smith" to "Johnny Smith Jr.", or "5006" to 50006" at to flag those rows some how. Thanks for any ideas. ... 18 Jul 2008 16:31