| Thread | Last Post | Replies |
|
| macro security cannot be changed | 04 Dec 2007 03:28 GMT | 2 |
I have an XP pro computer running Office 2000 that I uninstalled on our network and installed Office 2003. My user has some Excel documents that have macros. When she tries to run them, she errors out and is directed to the security settings. She changes the settings in
|
| Magic Formula Appearance | 04 Dec 2007 01:49 GMT | 1 |
Excel 2003 Win XP Home I use a simple worksheet which consist of five columns into which I add four figures of numeric data across a new successive row each day. The fifth column includes a sum formula to sum the entries on that row's four columns.
|
| Inner window frozen | 03 Dec 2007 22:47 GMT | 3 |
I used to be able to move the spreadsheet within the overall Excel window. Somehow I have lost this ability and the spreadsheet is now fixed. There use to be a blue title bar that I could use to move the spreadsheet around. What did I do? and how do I undo it?
|
| Converting Numbers to words | 03 Dec 2007 22:23 GMT | 7 |
I preapre inovices using Excel. I have to put the total amount in words I want to convert number to words. Example
|
| Excel VBA PARAMETERS | 03 Dec 2007 18:53 GMT | 4 |
Hi again! Could somebody tell me the name of the file containing the VISUAL BASIC EDITOR INFORMATION that I could copy from one machine to an other machine?
|
| Formula Error | 03 Dec 2007 17:00 GMT | 3 |
I have a spreadsheet, one sheet per month (ie November, December etc), which has this formula to calculate the daily average of sales (column P, and column U is for account sales, of which there may be not be any for the month), AVERAGE(IF(P10:P70>0,(P10:P70)+(U10:U70))) ...
|
| Subtable / Conditional Block of Cells | 03 Dec 2007 16:52 GMT | 1 |
Hello Group, I would like to have a group of cells in the bottom left corner with different content depending on the results of calculations in the sheet.
|
| Extending formulas/formats with imported tata | 03 Dec 2007 16:36 GMT | 2 |
Hi -- I have a worksheet that includes imported data. Several columns consist of row-specific formulas. How do I get Excel to automatically adjust these columns to account for more or fewer rows whenever I import new data?
|
| Vlookup | 03 Dec 2007 15:49 GMT | 5 |
Range1 is the name of the range d3:AA33 in the sheet "chart". This range represent 12 months of the year, for each month TWO colomn the first is for the date and the second has a value (a value for each day of the year). C7 in sheet3 has a date value.
|
| Workbook index | 03 Dec 2007 15:26 GMT | 4 |
I have developed a workbook, used as a route list, containing as many as 50 to 60 worksheets. Each of the worksheets has customer details and delivery information including time of delivery, which can change from day to day as customers are added or removed. In order to ...
|
| macro | 03 Dec 2007 14:54 GMT | 2 |
I have the below macro which works fine, but I need to add to it. Sub Button6_Click() Range("c12") = Range("c12") + Range("d8") Range("A8,b8,b7,c8") = 0
|
| dynamic macro help | 03 Dec 2007 14:38 GMT | 3 |
I have a list of PDF Manual files in ColumnP in ColumnQ I have VBA project that when the cell is selected it grabs the file name with cell.offset 0 -1 and opens the file in column P. My question is how can have a simple command that would do this to all rows (500) rather
|
| Flashing cells | 03 Dec 2007 14:24 GMT | 2 |
Is there a way either conditionally or through a formula that I can get a higher or lower figure to Flash in a color should it not reach the criteria? Cheers Haggis
|
| infor | 03 Dec 2007 14:20 GMT | 1 |
I have office 07, how do I have to tool bar open all the time on (home) instead of having to click on home to open the tool bars
|
| copy range and paste into every 3rd cell of new range | 03 Dec 2007 13:47 GMT | 4 |
I have 2 worksheets and I am looking for a macro that will copy a range of cells from one worksheet, then paste them to another worksheet, but leave 2 blank cells between each cell. sheet to copy from "MON" range: A7:A80
|