| Thread | Last Post | Replies |
|
| Hide Buttons When a Cell is False | 24 Jan 2008 20:12 GMT | 2 |
Is there a way to hide and unhide buttons when a cell is true/false? I use this all the time for regular formulas within excel, but am not sure if it is possible to hide actual buttons. Any help would be greatly apreciated. Thanks
|
| Copy/Paste Charts; Define Destination of Charts in PowerPoint | 24 Jan 2008 20:04 GMT | 2 |
I found this snippet of code on the web (thanks JP): Sub CopyChartsIntoPowerPoint() ''' COPY SELECTED EXCEL CHARTS INTO POWERPOINT ' Set a VBE reference to Microsoft PowerPoint Object Library
|
| importing more than 65536 rows from .csv file | 24 Jan 2008 19:38 GMT | 1 |
Hi I am trying import a .csv file which contains more than 65536 rows. I created a macro to import and it is successfully importing with out a text qualitfier. can any one help me how to import huge .CSV files to one excel
|
| Calculation/Number Bug in .xls? Any ideas? | 24 Jan 2008 19:37 GMT | 4 |
I just stumbled across this problem - i can sort it out using a rounding calculation but anyway i was wondering if anyone had a clue why it's happening. so, could you please let me know why this code fires "Not match"?
|
| Check if workbook open (Not working) | 24 Jan 2008 19:23 GMT | 3 |
My program starts with a simple form to create a new workbook or open an existing one. Once you do either, the form disappears and either opens or starts an new workbook. Once you close either the newly created workbook or the existing one, the form re-appears asking you the same ...
|
| Copy IF condition exists | 24 Jan 2008 19:00 GMT | 6 |
Is it possiable to Copy and paste if a specific condition exists? Heres the problem in column "F" there is a number. If that number is less then 61 i would like to move the entire row to another sheet. also the range will change with the data. can this be done?
|
| Delete Last 10 Rows in Worksheet | 24 Jan 2008 18:20 GMT | 8 |
I need a macro that can delete the last ten rows in the worksheet. Column A will always contain information on the last row, but has a lot of gaps in the rest of the column.
|
| Groups in Option buttons | 24 Jan 2008 18:09 GMT | 15 |
I would like to know how I can get the data from a group of option buttons. I have a group of 8 optionbuttons with the names "e1" through to "e8", the name of the group is "expenses" I am not sure how to use or if I can use a groupname vba. I am looking to have reason.text show ...
|
| Handling Errors When Opening Word Docs From Excel VBA | 24 Jan 2008 17:55 GMT | 1 |
I have written some logic in Excel VBA which opens Word files and then does some processing. I am having trouble catching all the errors from opening the Word files - my code is:
|
| Help Fixing a Macro | 24 Jan 2008 17:51 GMT | 2 |
I'm hoping someone could help me fix a Macro that is giving us problems. The Macro is probably badly written in parts (well the parts I have added anyway) because my VBA knowledge is poor at best. Basically the Macro imports a large csv file, converts the imported data to
|
| Need to get value of last number in a column | 24 Jan 2008 17:46 GMT | 2 |
I submitted this an hour ago, but it was never posted -- and so I apologize if it shows up twice. I have a column(s) of portfolio values, updated daily or weekly. I want to find the last number entered in the column so that I can compare it to the beginning of the year ...
|
| VBA solution required? | 24 Jan 2008 17:37 GMT | 2 |
Hi;
> > > > > I would like to know if there is a way to total items from one column from > > > > > different dept. numbers in another column. I will try to give an example > > > > > below: |
| List objects and Buttons | 24 Jan 2008 17:34 GMT | 4 |
I have a list object over a Button is there a way to keep the listo boject from rolling over the button? I have tried the Object positioning settings under format control with no luck. I need to have the button move down as the list grows.
|
| Selecting a dynamic name | 24 Jan 2008 17:21 GMT | 1 |
I'm looking for a relatively easy way to select dynamic named ranges. I know that you can type the name into the name box, but I don't always remember exactly what the name is. :-) My thought was to build a form and populate a combo or list box with the
|
| Using Variables in R1C1 formulas | 24 Jan 2008 17:09 GMT | 1 |
I am trying to create a formula in a cell to set the value of the cell equal to another cell that is a varible number of cells away. for example Dim x As Integer
|