| Thread | Last Post | Replies |
|
| Filter pivot table results without filtering in SQL query | 27 Nov 2007 16:33 GMT | 1 |
I have a pivot table setup witht he results I need,however I need to only see those results that are of a specific age (15 days of older, 30 days or older etc). Is there a way to filter my results so they show only that relevant age data by a drop option, so I can always use the ...
|
| Find and colour all cells with Validation | 27 Nov 2007 16:32 GMT | 1 |
Looking for VBA that will turn cells blue, if they have any validation rules applied to it. Is this possible? How? I have something similar that makes all unlocked cells Yellow. It works like
|
| Advanced filtering of Union of named Ranges | 27 Nov 2007 16:07 GMT | 1 |
First off, apologies if this has been discussed elsewhere. I've been looking for two days w/o success. First, I'll describe what I'm trying to acomplish, what I have done so far and what I came here to get help on.
|
| Lost My Personal Macro Workbook - Thanks Ron de Bruin! | 27 Nov 2007 16:04 GMT | 1 |
I posted the question below and received the solution from Ron de Bruin. This is an FYI in case anybody else experiences the same problem. I did not know the Disabled log was available and also found a couple of Add-In DLL's that I had "lost." So great piece of info.
|
| Menu Restoration | 27 Nov 2007 16:02 GMT | 3 |
I have removed inbuilt Excel menus and replaced them with mine. Now if I need to get back Excel to the default look I have restore the menus one by one. Although it is a one minute task I like to know if it can be done with a push of a button that is with with help of codes. If ...
|
| Excel Question | 27 Nov 2007 15:41 GMT | 2 |
I have an excel spreadsheet containing the following sells that are in questions. I would like to input a formula that will calculate the DOM (Days on Market) based on 1. Status = Active (Y)
|
| Email using Outlook | 27 Nov 2007 15:35 GMT | 1 |
I am currently producing a rather large spreadsheet on a daily basis, which is automatically saved to sharepoint. This is great, but I would also like to generate an email which sends only a link to the file in the subject field of the email, with perhaps a message in the body o ...
|
| get from Excel 2003 add-in to Excel 2007 add-in | 27 Nov 2007 14:49 GMT | 5 |
All, OK, I know I am having a mental block, but I cannot seem to transfer my 2003 add-in to a 2007 add-in. I opened the AddIn.xls with Excel 2007 and saved it as a .xlsm. Then when I open the .xlsm and try to
|
| Opening form in VBA. No error,code just breaks.Works on other PCs! | 27 Nov 2007 14:49 GMT | 1 |
Morning all! ((Im using 2003)) I have a button which is supposed to open a userform (which performs a data scrape after users enter login info and hit enter.. )
|
| Complete Excel VBA Reference | 27 Nov 2007 14:40 GMT | 3 |
I am looking for a Reference on Excel VBA. One that has the complete list and details on all Excel Objects-Properties-Methods etc.
|
| Hide rows within a range IF... | 27 Nov 2007 14:31 GMT | 4 |
Newbie here so any help is appreciated. Within the active worksheet, within the row range of Row 7 thru Row 1004, if the value in Column CK for that Row is = 0, then hide the entire row.
|
| hash value of range | 27 Nov 2007 14:08 GMT | 2 |
Simple question. Is it possible to make a hash value (is that the correct phrase?!) of a range of cells in vba? Suppose I had the following ranges: range1:
|
| How to get count summary of number that corolates with a name? | 27 Nov 2007 14:07 GMT | 2 |
I have a column that has multiple divisions (groups), and another column that has the severity level for that particular item (could be 1,2,3). Example Group Severity
|
| Custom tooll bars in excel 2007 | 27 Nov 2007 13:31 GMT | 1 |
I have made custom tool bars with menus and macros attached in excel 2003 Having upgraded to Excel 2007, I can see the custom tool bars in the addins tab but when I try to use them the path isn't recognised.
|
| messagebox macro | 27 Nov 2007 13:26 GMT | 1 |
i have the following macro running off a button to call a messagebox before a macro is run; Sub Reconcile_Button() 'button to run "reconcile" macro, first runs dialogue box with YES/NO to
|