| Thread | Last Post | Replies |
|
| Calc error | 07 Jan 2006 16:18 GMT | 2 |
Got a tricky error in my Excel (2004 for Mac, Version 11.2 (050714) The difference between the two figures: a1 6833.40 a2 6828.66
|
| Rounding | 07 Jan 2006 15:31 GMT | 2 |
Hey guys, first time here. I am working with some formulae... they are pretty simple - its for using to figure out the FIT deductions to apply to my employees wages. Anyway, I have the formulas just right except now I need to apply
|
| Scanning a Number into Excel | 07 Jan 2006 15:29 GMT | 2 |
I am trying to scan a number that is 24 digits long into an Excel spread sheet. I have formated the cells to numbers and removed the decimal places and it scans into the cell but when i move to the next cell it changes the last 9 digits to 0. Is there some way to keep all the 24
|
| Link to a changing cell? You'll see... | 07 Jan 2006 15:21 GMT | 4 |
Is it possible to have a hyperlink between two sheets that jumps to th cell that is displaying today's date? I want to have a link from one worksheet, that when pressed takes me t a different worksheet, but on the this new sheet locates the cell whic
|
| "Show Placeholder" feature in options/view doesnt work | 07 Jan 2006 15:00 GMT | 1 |
I have a macro that places a large number of pictures on a spreadsheet. I would like the pictures to show as "placeholders" to speed up viewing/editing. The only problem is that this feature (under Tools/Options/View) does not work. All the images are being display normally. I ...
|
| Inserting a VB formula with a quote problem | 07 Jan 2006 13:47 GMT | 3 |
I want to insert a formula into a specific cell, something like ActiveCell.FormulaR1C1 = "=EOMONTH (Now(), -1)" This works fine and gives me the last day of last month. But this doesn't work because of the "
|
| I would like to compress the x-axis of my graph | 07 Jan 2006 13:36 GMT | 1 |
I would like to remove a section of the x-axis of my graph to read so that the axis reads 0,1,2,3..........10,11,12,13 instead of 0,1,2,3,4,5,6,7,8,9,10,11,12,13,
|
| Accounting Category Display does not show the correct format/outpu | 07 Jan 2006 13:30 GMT | 5 |
My apologies if this is a known bug or I am missing something... On a worksheet in a spreadsheet, I have some cells already having numeric values in. When I try and format to Accounting Category, they remain as eg 4.4, 0.9 left justified, rather than 4.40 and 0.90 right justified ...
|
| Put Active Worksheet's Name in a Cell | 07 Jan 2006 12:40 GMT | 1 |
Is there a way to put the active worksheet's name in the cell? Not the file name of the whole workbook, just the name of the currently selected sheet. Thanks for your help.
|
| Put Active Worksheet's Name in a Cell | 07 Jan 2006 10:53 GMT | 1 |
Is there a way to put the active worksheet's name in the cell? Not the file name of the whole workbook, just the name of the currently selected sheet. Thanks for your help.
|
| Delete Duplicate Text | 07 Jan 2006 09:15 GMT | 1 |
I have a work book inside this workbook there are 7 work sheets (one for each day). Each sheet uses columns A, B, C, D I have sheet call weekly all in formation in this sheet from the 7th everything work fine only one column it has text and there are several
|
| Can a macro general a message box with several inputs and outputs? | 07 Jan 2006 08:53 GMT | 1 |
I want to set a button in my workbook which generates a message box with several inputs and outputs. Let's say there are several text box in the message box. Can it be done with VBA? Thanks in advance.
|
| Row Height | 07 Jan 2006 08:51 GMT | 2 |
When you try to increase/decrease row height a box appears with a number of the present size which you can change and it will change the height. Can you set up the box to allow the set up to be in inches?
|
| looking up stuff =o( | 07 Jan 2006 07:45 GMT | 2 |
i need some help looking and replacing some stuff up...i cant seem to come up with a combo of functions that work. what about a macro? I need to find A1 in column B, then replace that cell in B with the corresponding value in C1 and so with over 500 values in column A.
|
| Master Workbook/Form | 07 Jan 2006 07:41 GMT | 4 |
I have a workbook that contains a user form with 4 command buttons (named IMSTOOLS). Each button is connected to a different workbook. When a command button is selected, I hide IMSTOOLS and open the
|