| Thread | Last Post | Replies |
|
| SEND MAIL TO DIFFERENT ADDRESS WITH DIFFERENT MESSAGE | 30 May 2008 13:50 GMT | 1 |
I have a sheet in which various informaation are there regarding each client and issues related with that client. I want a macro that can send mail to that client with the issue related to that particular client . I have below the format of the table
|
| Registry syntax to ensure that an addin is opened readonly ? | 30 May 2008 13:31 GMT | 3 |
It's been a long time since I've visited this forum where I used to be a very frequent poster. Hi to all my old friends. Question: I must ensure that an addin is opened in readonly mode, by all users
|
| Importing a single cell from one .xls to another | 30 May 2008 13:24 GMT | 2 |
I'm hoping you can help me find a simple method to a problem. I was importing a .xls file using the External Data tool into my worksheet which worked find. I now have a requirement to import data from reports generated each
|
| VBA Code for FIND values | 30 May 2008 13:22 GMT | 3 |
What I'm looking for is the VBA code to FIND the content of cell F8 sheet1. Basically I've been trying paste cell F8 into EDIT FIND, "This cell value changes sometimes" Hope I've been clear in my question.
|
| new menu opens in all worksheets | 30 May 2008 13:00 GMT | 1 |
Using the following code, I fiind that the new menu appears in every excel worksheet that is opened instead of appearing only in the worksheet it belongs to. I've placed the code in the "ThisWorkbook" module.
|
| Conditional Formatting with VBA | 30 May 2008 12:57 GMT | 5 |
I though this would be easy, but I can't get it right, any help would be greatly appreciated. I'm trying to go down Column "D" (about 250 rows) and when the contents of a cell = "HOURS" go to each cell to the right (31 cells) and if the contents of
|
| Changes to entries made through validation | 30 May 2008 12:57 GMT | 1 |
I have users select items from a validation list that dynamically displays the list items in the language of the user's choice and then enters that item in the language selected. The problem is if another user changes the language for the spreadsheet, the entry made through the ...
|
| PrintPreview of multiple sheets under Excel 2007 | 30 May 2008 12:51 GMT | 1 |
In Excel 2003 and older, I had a macro running that was selecting multiple sheets and was presenting the result under printpreview mode to the user. Exiting this mode (after a print or a close selection by the user), that same macro was un-selecting the sheets and replacing
|
| Create function to find a value in an array in seperate worksheet | 30 May 2008 12:43 GMT | 1 |
I am looking to create a VB fuction to use a stock reference in a cell (A) from one workbook, to reference the correct column of information corresponding to cell A and return the contents of the cell based its 3rd element and the 4th element.
|
| macro speeds | 30 May 2008 12:29 GMT | 13 |
Under Pressure back online again looking for support. I have a small spreadsheet, 42 rows and 14 columns,with about 20 rows (195 cells in total) of conditional formats, 6 graphics,lots of text, numbers and formulae.
|
| Open Office Outlook & Insert e-mail address | 30 May 2008 12:04 GMT | 3 |
Is it possible (Using CmdBtn / VB Code) to open microsoft office outlook and insert recipient(s) e-mail address(s). Generally I send a workbook via SendTo/As Attachment in the dropdown, then insert the e-mail addresses, different workbooks are mailed to pre-set
|
| Simple iteration problem. Help | 30 May 2008 12:01 GMT | 1 |
Hello everybody, i'd like to do the following iteration with excel 2007: x1 = f(x) so i want to find a value of x that gives me: (x1-x = 0) i hope somebody will help.
|
| Master xls to CSV | 30 May 2008 11:54 GMT | 4 |
I have a huge costing excel spread sheet for which I need to convert-export to several different CSV files so our CRM can read. Anybody have a formula for how to do this?
|
| Avoiding verbose code | 30 May 2008 11:52 GMT | 4 |
Two custom menu buttons execute the same basic code but with one additional function provided by the second button. To avoid repeating the basic (lengthy) code in two modules it would be great if I could detect which button was selected.
|
| How to retrieve the last selected cell before SelectionChange even | 30 May 2008 11:20 GMT | 2 |
I am using the SelectionChange event like this: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Intersect(Target(1, 1), Range("m1:m1")) Is Nothing Then Exit Sub ...
|