| Thread | Last Post | Replies |
|
| Interuption with no explaination :/ | 16 May 2007 16:20 GMT | 3 |
Hi. I've had this error a couple of times, and can't figure it out. I write a macro and when running it I get "Code Execution has been interupted" and when I debug it's on random lines... Today i've wrote a macro, which I'll attach at the bottom. The macro worked
|
| Answer MSGBOX Programatically | 16 May 2007 16:07 GMT | 6 |
I am writing a macro that opens other workbooks, calls macros in these workbooks to update data and print some sheets. When all of that is finished, there is a msgbox funtion that let the user know this process was completed.
|
| writing a macro to delete all rows after a certain value | 16 May 2007 15:17 GMT | 3 |
I'm trying to write a macro for a spreadsheet that will have a variable number of rows, but generally in the neighborhood of 18,000 to 19,000. Here is what I have, but it takes about 5 minutes to run so I'm trying to find a faster way:
|
| Command button code | 16 May 2007 14:33 GMT | 6 |
I have created a command button on a worksheet in an Excel 2003 workbook. I just need to assign some code to this button so that when clicked, it will simply enter text into a cell in another worksheet in the same workbook.
|
| copy from worksheet | 16 May 2007 14:32 GMT | 3 |
Having the name of a worksheet in cell A1, I would like to extract non-contiguous data from the sheet of that name and paste it onto my "Data temp" sheet. How can I get the data to extract from the named sheet onto the Data Temp
|
| SCripting Border in Excel | 16 May 2007 14:17 GMT | 2 |
I am writing a script to populate an excel speadsheet. All works ok until I try and but borders around the results. The snipet of code below is how I have tried to create the borders but with ne results.
|
| The Macro "C:\Test\Something.xls!Macro" could not be found | 16 May 2007 14:11 GMT | 4 |
I guess this is somewhat a silly question, but I'm not able to figure it out. I have made a macro, and I have assigned it to a button in the toolbar. But when moving the Excel file to a different location, it can not find the macro. How do I make it work wherever I put move the ...
|
| date format changes when I save to CSV via a macro | 16 May 2007 14:06 GMT | 1 |
(reposted from General Questions) (note: this behaviour seems to have appeared in Excel 2007 - in Excel 2003 the macro worked fine!)
> brawlsadford wrote: |
| Import data with Webquery | 16 May 2007 14:06 GMT | 1 |
I need to import data from web pages but I need only data from certain cells, not the whole table. Excel lets me select tables only. Can anyone suggest a solution for selecting individual cells as source? Thanks.
|
| Re : Excel Creation of a New Copy and the Duplication of Names thereof | 16 May 2007 14:05 GMT | 1 |
Re : Excel Creation of a New Copy and the Duplication of Names thereof 1. Enter an Excel workbook and construct a table on Sheet1. 2. Construct a similar table on another Sheet. 3. The natural tendency is to create a new copy of Sheet1 and
|
| Excel 2003 | 16 May 2007 14:01 GMT | 1 |
Dear Excel Expertises, I have an Excel spreadsheet of with features and models. It looks like this in excel. The first column contains all the features and the first row contains all the models.
|
| How to determine the worksheet that a calculate event gets initiated on when the workbook is not active | 16 May 2007 13:58 GMT | 3 |
I have 2 workbooks thats are linked with a cell reference. I make a cell change on book1 and a cell in book 2 changes. I want to be able to get the name of the sheet that the calculate event runs on in book2 to hide rows that do not contain values. Currently my code runs on the
|
| Array formula with IF | 16 May 2007 13:53 GMT | 4 |
I cannot work out what is wrong with my formula: =IF(B3:E3-A3>=3,1,0) I would like if any of the values in the range are greater than 3 more than the value of A3 a "1" to be returned as I eventually will use the formula for conditional formatting. When I enter this formula it ...
|
| Add-In Password...! | 16 May 2007 13:35 GMT | 1 |
Could some one help me to recover my AddIn Password. Thanks, Thyag
|
| Visibility of contents in a merged cell | 16 May 2007 13:26 GMT | 4 |
First I explain below what I did; I merged cells from a1 to e17. Formatting : Left, Top and yes for wrapping. Then I kept key 'i' until the cell got filled up.
|