| Thread | Last Post | Replies |
|
| Compare two columns, delete rows that match? | 24 Apr 2008 08:31 GMT | 1 |
I would like to compare columns B and C, and, if they match for a given row, delete or hide that row. B and C will be numbers (A is text) and as I am new to development in general, I unfortunately have no code to post. Any help would be much appreciated. Since this tool will ...
|
| VBA / Formula | 24 Apr 2008 08:18 GMT | 2 |
I have a formula I am trying to put into vba format. I have the formula working fine in the cells themselves, but it takes a long time to calculate and recalculate. Can anyone help me put this formula into the proper syntax?
|
| Edit VBA Code without opening the workbook | 24 Apr 2008 07:45 GMT | 9 |
I have VBA event code in an EXCEL workbook that goes into a never-ending loop. I know what the problem is -- it triggers its own event! -- but I don't know how to edit the errant code without opening the workbook. Is there a way to edit the code without opening the workbook?
|
| Save & Load A Range | 24 Apr 2008 07:33 GMT | 5 |
Wonder if something like this is possible - 'air' code to show example. -- Dim zz As Range
|
| Help with Vlookup of Find date | 24 Apr 2008 07:28 GMT | 1 |
I would like help. I have a workbook open. I would like to look at a closed workbook or or open it whatever it's name may be (changes every week) at column B2 to B80 and find the corresponding text in the same location as my open workbook. In the closed workbook I would like ...
|
| Dynamic comboBox on Ribbon | 24 Apr 2008 05:34 GMT | 5 |
Is there a good example of how to dynamically populate a comboBox on a custom tab on the Ribbon? Say from a list of items on a spreadsheet or from an array? If so, could you point me to it? Thanks much in advance.
|
| replace copy and paste | 24 Apr 2008 04:50 GMT | 2 |
I have below macro recorded and would like to replace copy and paste with = Formula if possible. Range("D8:H8").Select Selection.AutoFilter
|
| I need help with a "Run-Time Error 13: Type Mismatch" | 24 Apr 2008 04:35 GMT | 2 |
Hi group. Im getting an error that I dont understand with this macro I wrote for excel. Im a begineer to VBA but this code also stumped an experienced programmer that i showed and I would really like to know what the problem is. If anybody would care to read through it (I
|
| If ...Then Statement | 24 Apr 2008 04:26 GMT | 8 |
Group, I have a worksheet change evenet that I want to be able to toggle with a named cell value. Private Sub Worksheet_Change(ByVal Target As Range)
|
| Code format question | 24 Apr 2008 03:31 GMT | 3 |
Hi Group, Just for the life of me can not remember the code which I used in the past to format combined variables. First Variable should be (Fixed,Comma,2) and the second should be as a %. It is the Fixed, Comma, 2 I am having trouble
|
| Using More than 7 possibilities in a formula | 24 Apr 2008 02:14 GMT | 2 |
How do I use more than 7 possibilities in a formula. I know basically you can't nest more than 7 formulas in one. Any suggestions would be helpful
|
| Previous active cell | 24 Apr 2008 00:41 GMT | 2 |
Is there a way to capture the address of the last previous active cell. I am trying to do this in the selection change code of a sheet but I cannot make it work. Thank you,
|
| Excel 2007 Macro Security | 24 Apr 2008 00:20 GMT | 3 |
I used a tip from this forum on using the Workbook_Open event in Excel 2003 to determine if macro security levels would allow macros to execute. With that, instructions could be provided to the users on how to change their macro security level in order to run macros in Excel ...
|
| Refresh form | 24 Apr 2008 00:14 GMT | 1 |
To update the items on a userform I am using "userform.hide" and "userform.show" at the beginning and end of the procedure. Is there a better way to update the data on a userform? Thanks
|
| Protecting sheet through vba while allowing some actions | 24 Apr 2008 00:12 GMT | 3 |
I've done a lot of searching on this but am stuck - I'm guessing the answer is simple - basically, I have a large file with 65 sheets -- on 15 of these sheets, I would like to have them protected, but still allow the user to do things such as sort, autofilter, format, and a few ...
|