| Thread | Last Post | Replies |
|
| How can I get Euros in the taskbar of Excel 2000 | 23 Jun 2006 06:22 GMT | 2 |
Does anybody have the software to put Euros in the taskbar of Excel 2000?
|
| Simple code to append numbers to the existing data in the cells | 23 Jun 2006 06:02 GMT | 1 |
I have many colums of data (characters) What I want to do is, highlight the required cells in the column and then either press a button or whatever to trigger the code to run. The code should append numbers to the existing data.
|
| Is is possible to set a border NOT on the edge of a cell? | 23 Jun 2006 03:29 GMT | 1 |
I am looking to create a macro that either pastes a mini-image or formats a diamond shaped border in each cell of a selected range. I know how to do the macro, but cant figure out either how to paste an small image in each cell or add a non-traditional border.
|
| Sum the greatest run of negative numbers | 23 Jun 2006 03:18 GMT | 7 |
I have a list of returns like that listed below, I want to find out the greatest continuous run of negative returns, (i.e. -24-3 =-27, and is greater than -2-4-3-1-1-1=-12) so it would return a result of -27
|
| speech feature in excel | 23 Jun 2006 02:58 GMT | 3 |
How can I detect if the speech feature is installed in Excel?
|
| Excel window closed but process still running | 23 Jun 2006 02:44 GMT | 2 |
I'm using C# application to open an Excel workbook by using m_objExcel = new Excel.Application(); and it works fine but problem arises if user close Excel window and go back to my C# application to open another excel workbook. the workbook
|
| pivot tables | 23 Jun 2006 01:29 GMT | 1 |
Hi, i get pivot tables on a weekly basis. the data is to big to open in excel. is there any way to get the data out of the pivot table into a text file and then for me to import into a database. i do not have access to the data source of the pivot tables. any vba script or ...
|
| color on text in a cell | 23 Jun 2006 00:39 GMT | 4 |
How do u modify data in a cell with different color text thru VBA. I want to append data with a different color to the existing cell.
|
| How Do I Use an XLL Add-In Function from Code? | 23 Jun 2006 00:37 GMT | 1 |
My question, short form: I have an Excel Add-In, packaged as an XLL, which contains a worksheet function -- let's call it F(). Can I use F() from VB/VBA? If so, how? My question, long form:
|
| write array to range | 23 Jun 2006 00:36 GMT | 8 |
I'm picking up Excel VBA again and have some trouble with this: Range("b2", "b501") = NPV, where NPV is an array and it looks OK, but the output is all the same, 500 of the first element, what's wrong?
|
| Stop marco allert and update link allert when opening spreadsheet | 23 Jun 2006 00:15 GMT | 1 |
When the macro security settings are set to High or Very High, i get a warning each time I open a spread sheet that states that macros are turned off. I dont want to see this warning at all. Like wise, if a spreadsheet has links that need to be updated, when i open
|
| conversion of text to numeric | 23 Jun 2006 00:14 GMT | 2 |
In a macro I have the following code Cells(rs, cl) = Cells(7, 19) What can I change to this or add after it that will force the numbers to be numeric instead of string?
|
| convert table of hyperlinks | 23 Jun 2006 00:03 GMT | 1 |
I have a large table (over 600 entries) of hyperlinks. They are all in a single column. They are all of the form: =HYPERLINK("http://www.something.com","something") I need to convert the table into a table of hyperlinks without function
|
| module moving | 22 Jun 2006 23:22 GMT | 2 |
How do I insert a new module in between exisiting ones and have the order change or rename the modules
|
| Question about sizing Userforms programmatically | 22 Jun 2006 23:19 GMT | 2 |
Windows XP Pro SP2 Excel 2002 SP3 I have a Userform that I like to change the size of as I progress through various steps of a setup wizard that the Userform in question serves as the
|