| Thread | Last Post | Replies |
|
| Multiple Modules in the same workbook? | 26 Jun 2006 08:51 GMT | 6 |
Is there problems with having more than one module in a workbook. I've created a second module because I need to 'Sub DeleteModule()' for one of them because it contains the 'Sub Auto_Open()' which I don't want to carry over when I SaveAs.
|
| Macros using Add-Ins | 26 Jun 2006 08:23 GMT | 1 |
I have a problem with the EasyFilter Add-in (by Ron deBruin MVP) and its use in a Macro which I cannot seem to fix - or even find a solution to on the Internet. I have just started my journey with Macros in order to help me clean
|
| Parsing Characters - Bug ??? | 26 Jun 2006 07:59 GMT | 10 |
I have a complex macro that parses characters in the active cell and makes changes to the worksheet. However, if the macro is run after opening the wb before any manual cell entry is made (as opposed to clearing contents or pasting etc.) then the macro runs very slowly. This is ...
|
| AutoFilter Data | 26 Jun 2006 06:28 GMT | 2 |
I have a C# code that use an excel appliction. In my code, I use the AutoFilter in a certain range. My question is how could I get the return values of the autofilter and manipulate/scan the return data. Below is my code taken in a certain procedure:
|
| macro to search and list data | 26 Jun 2006 06:19 GMT | 2 |
is their a macro that will look threw a page of data and report on another page a list of results based on information in a percific col colums A to I contain data want to search col G and do a report on every event that does not contain
|
| Help with blinking text | 26 Jun 2006 05:11 GMT | 2 |
I am current using the blink text code found at www.cpearson.com but I would like to make it so that if I were to change a value in a cell that it would then start blinking. So for example: If cell A1 changes to 80% or lower then make A1 start blinking. Also, I would like to ...
|
| Create New WB with copy of Sheets 1 & 2 when sheets count reaches 100 | 26 Jun 2006 04:52 GMT | 5 |
What i want to do is create a New workBook, when the number of worksheets reaches 100. I have a button set up to create a new record(sheet) from a Template (Sheet1) in a workbook. To save over sizing and increasing the chances of a file crash, i want to have the WB, if the create a ...
|
| Desktop shortcut | 26 Jun 2006 04:38 GMT | 3 |
Is it possible to have the activeworkbook when it saves for the very first time to automatically put a shortcut onto the desktop? I can work out how to have the code activate for the first time, just not how to get a shortcut to the desktop
|
| Excel and Visual Basic | 26 Jun 2006 04:14 GMT | 2 |
Hello, I am trying to create a command button in Microsoft Excel (Office 2000) that enables me to reset the check box status for a worksheet from checked to unchecked. The worksheet contains approximately 50 check boxes and is meant
|
| Excel VBA Macro Running DOS Application !! | 26 Jun 2006 03:59 GMT | 11 |
Hello; I would very much appreciate your expertise on how-to! In myBook1.xls, I've a VBA macro, say, Sub myMacro (), which generates, compiles, and saves a specially unformatted data file, say, myInputFile =
|
| datestamp a comment into a cell | 26 Jun 2006 03:54 GMT | 1 |
Is it possible to have the date in which a comment is editted populate into an actual cell?
|
| Match in VBA | 26 Jun 2006 03:28 GMT | 7 |
I have some dates in column E (starting from 31-Jan-2005 to 31-Oct-09 -- 3 Month stretch) If I put the following formula in my excel worksheet =MATCH(TODAY()-1,$E$2:$E$21,1)
|
| Procedure not running automatically... | 26 Jun 2006 03:21 GMT | 1 |
The 'Private Sub Workbook_BeforeClose()' isn't running automatically (or at all for that matter). I've got the code in a module of it's own("B4Close") along with the 'Sub CopyData1' procedure. But when I close the Workbook it doesn't
|
| copy and insert entire row based on integer in column A | 26 Jun 2006 02:18 GMT | 8 |
I have a spreadsheet that contains data as follows; 3 rgf rhh 2 xyz abc 4 ejerr
|
| Is it possible to join columns where there is a match? | 25 Jun 2006 22:59 GMT | 1 |
Any guidence here will be much appreciated. It it possible to have one worksheet with unique values and anothe worksheet with values realated to those unique values in a secon worksheet, and have a routine where either import the second workshee
|