Programming

too many arguments error message in excel
I am trying to use a lookup formula in excel and it was working fine until I entered FALSE on the end, at whcih p[oint it tells me I have too many arguments. This is the formula: =LOOKUP(A4,'C:\Documents and Settings\temp\My Documents\[AE prices for spares.xls]Sheet1'!$B:$B,'C:\Documents and Settings\temp\M... 22 Feb 2010 11:52

seperate
I have a report that i get taht I get the persons last name and payroll id in the same cell. the way it shows is as follows: sarrasin [000000] I want to basically run it through programming that will seperate it into two cells. is this posible to do as I have 2000 entries and as you can imagine it can be qui... 22 Feb 2010 11:52

Need a UDF to count blank cells
HI , and a good day to all programmers I need a UDF , which to count non blank cells above the cell which contain this UDF . When the UDF find the first non blank cell , to stop the count . Example : A1 - nonblank A2 - blank A3 - blank A4 - blank A5 - UDF here , the result of UDF from cell A5 must b... 22 Feb 2010 10:45

Timer that auto-closes workbook?
Is it possible (or even wise) to automatically close and save a workbook after a couple minutes of idle time??? If so, how would you implement the timer? thank u ... 22 Feb 2010 05:15

Opening two workbooks
I am building a new database in Excel2007 with each record having Quote Type, Quote Number and other fields. At present a Quote Type workbook is opened. Then the Quote Number workbook is called from within this Quote Type workbook. Then various information is pasted into the Quote Type workbook from the Quo... 22 Feb 2010 02:00

Moving a row
I am trying to move a row from Sheet2 to sheet1. I keep getting an error in my first attempt: Sheets("Sheet1").Range("A4:XX4") = Sheets("Sheet2").Range("A1:XX1") Error code: Application-defined or object-defined error ... 21 Feb 2010 17:11

Code to send SMS text message?
Hi, I would like to send an SMS text message to a cel phone via code within Excel 2007. Has anyone done this? What code / services / products do I need to accomplish this? Does anyone have an example? Thanks in advance. --Dan ... 20 Feb 2010 15:47

Cascading Combo Boxes - Sample Working Code
OssieMac, Would it be possible to provide a file of the code you posted here? I'm using Excel 2003, and even though I'm copying and psating the code, the Combo Boxes end up being empty when I run/submit the form with the 3 Combo Boxes. Thank you, OssieMac. OssieMac wrote: Hi again Brian,I see you have post... 20 Feb 2010 12:26

Question Responses
Two Questions: 1. I have a program that is intended to run unattended. It runs, collects data and then closes all open workbooks. However, when it closes a workbook it asks "Do you want to save changes?". That requires an operator input. How do I avoid getting the question? 2. To start the process unattende... 20 Feb 2010 14:41

TOUGH MACRO - DARE TO CODE IT
hi i am just a novice at the vba . now i have been asked to submi an assignment that is: 1)Create a workbook having a button. When the user presses the button, it should sort the data in sheet1 & then add subtotals to it. The parameters required for sorting & subtotals are specified in the sheet2. ... 20 Feb 2010 16:54