| Thread | Last Post | Replies |
|
| How to find the Day of week in a Month | 22 Sep 2007 08:38 GMT | 1 |
Good morning, How can i find the "Day of week in Month". For example : In this month if i enter the date as 01/09/2007 , is should reply - 1 (this 01/09/2007 consider as first week of this month)
|
| How do I set up a progm that allows entry of daily tips.Waitress | 22 Sep 2007 08:28 GMT | 1 |
I am college graduate for computers. I'm trying to figure out what program to use and how to use it. I have a brand new laptop compaq presario notebook. I want to be able to log in my acual tips each day and be able to store them in a program.....
|
| OpenText Method with "StartRow" as a variable | 22 Sep 2007 05:00 GMT | 2 |
I need to parse a text file and paste the result in the active workbook. I need "StartRow" to be the same row (a variable row number) that contains the word "SALES" in the text file. Is this possible?
|
| Displaying A custom menu as a popup menu | 22 Sep 2007 04:40 GMT | 5 |
I've created custom a custom menu with various macros, how can I display this as a popup (shortcut) menu when a cell is right clicked?
|
| Writing array data to range object always writes 0's on worksheet | 22 Sep 2007 03:54 GMT | 5 |
Hello Excelers! I have a program that subtracts time values on a worksheet and is SUPPOSED to write the diff to a worksheet row (same column).
|
| Automated Search and Replace; Sheet2 to Sheet1 | 22 Sep 2007 03:48 GMT | 3 |
I have a customer spreadsheet with over 5000 rows in it. Each week I get information that needs to be updated (100s of rows). The new information contains Customer Number and Paydate. I manually search for the customer number, located in column C, and then update the PayDate ...
|
| Pivot Table Data format | 22 Sep 2007 03:17 GMT | 1 |
I have a Pivot Table and of course when I double Click one of the totals it fires up a new worksheet with my data. I have a Macro that formats the worksheet the way I want it to look for printing. Is the a way to fire up the macro when I double click one of the totals.
|
| Creating a toolbar that works in Excel 2000 and 2007 | 22 Sep 2007 03:01 GMT | 3 |
Could someone please point me to sample code that generates a toolbar that will work in both 2000 and 2007? Until 2007 the following code worked well: With Application.CommandBars With .Add(mcstrToolbarName, , False, True)
|
| adding multiple spreadsheets onto one to sum up values | 22 Sep 2007 01:01 GMT | 1 |
i need to find a way of copying 4 or 5 spreadsheets together to the the total sum value of all spreadsheets any ideas??
|
| Address Referencing | 21 Sep 2007 23:13 GMT | 1 |
When generating a formula for a given cell through VBA, I need to be able to combine a relative reference (of form of R[x]C[y]) and an address retrieved from a different sheet (of form Sheet1!A12). When the VBA accomplishes this, the cell reference is invariably returned as a ...
|
| Pass array of sheet names to subroutine | 21 Sep 2007 22:48 GMT | 7 |
I want to insert a row in one or more adjacent sheets. I have written a subroutine: Sub sbrInsertRow(ParamArray avarSheetSub() As Variant) With Worksheets(avarSheetSub())
|
| Max Name Ranges Allowable in Excel 2003 | 21 Sep 2007 22:34 GMT | 1 |
Dear All: Does anyone know the maximum number of name ranges that I can create in Excel 2003. Thanks!
|
| Import Web Page | 21 Sep 2007 22:19 GMT | 1 |
This is what I am Using at the moment. Sub Import_Web_Page() Dim strDriver, intCount, intLastrow 'Import Webpage with external data query
|
| Copy and Past Macro | 21 Sep 2007 22:18 GMT | 3 |
I have a formula that looks for matching criteria (in cell I1 vs. Column A) and copies the values to the right of it and pastes them in E (starting with E1). What I need to do is the same except the last part (starting with E1).
|
| Clear print preview dotted lines? | 21 Sep 2007 22:00 GMT | 1 |
After I did a print preview, dotted lines appeared on my spreadsheet indicating where the page breaks will be when I print. How can I clear them? Thanks.
|