| Thread | Last Post | Replies |
|
| Help with a custom label? | 24 Jul 2006 17:47 GMT | 2 |
I want to replace the default format for cell d18 with a custom label of "Customers", I know i need to use the quotation marks around Customers but i am unable to get it to work. here is a sample of what i'm working on
|
| New Workbook Defaults to Personal.xls | 24 Jul 2006 17:45 GMT | 2 |
Whenever I start a new instance of Microsoft Excel, the default filename is Personal.xls, instead of Book1 (or whatever...) Since I have some procedures built into my Personal Macro Workbook, can I change the default name of a new Excel workbook?
|
| Workbook import | 24 Jul 2006 17:32 GMT | 1 |
In Workbook 1, I am running a macro that uses this code to select a file and copy A:Z on the main worksheet: Dim myBk As Workbook Set myBk = Workbooks.Open(Application.GetOpenFilename _
|
| Excel default number format problem | 24 Jul 2006 17:24 GMT | 1 |
I have a user with an incorrect default cell format in Excel. His default number of decimal places for a cell with numbers is set to 4 instead of 2. I have no idea how he caused this and I have no idea how to correct it. In case I'm being ambiguous, here is the procedure:
|
| HOVER over a cell | 24 Jul 2006 17:21 GMT | 1 |
is it possible to have a cell pop up or become 3D when the mouse hover over it?
 Signature just1creation
|
| Need a Pause in a macro | 24 Jul 2006 17:03 GMT | 2 |
I have a macro that goes out and retrieves data from a text file opened with Excel, then pastes the data back in my worksheet and closes the text file back up. For some reason, the data that is being brought in is being inserted in multiple columns because it is using a space
|
| new line in mail in notes from VB | 24 Jul 2006 16:50 GMT | 1 |
Hi, I have set up a bit of VB code send automated mail from Excel..... however i dont know how to start a new line in the mail.... everything I enter goes on the same line. Does anyone know how i can put tables into my automated mail, or even
|
| Selecting cells containing spcific character(s) | 24 Jul 2006 16:26 GMT | 1 |
Hello, I need to know how to get Excel to select all cells within a specific column that contain a specific character. In this instance, I need to select all the cells which contain a comma...
|
| Williams/ACLCconference2006 in Excel | 24 Jul 2006 15:25 GMT | 1 |
I can't seem to find the file labeled "Williams" in the Excel site and I'm pretty sure I saved it when I finished it yesterday. Please somebody help me as I am quite new at this other than typing!
|
| AND(), OR() in EXCEL | 24 Jul 2006 14:27 GMT | 4 |
In general case, how can i use the AND() and OR() in a column?. For example lets say that I have a column (A1:A100) with numbers, text and blank cells. How can I say: 1) If one cell is number then give me the SUM of the column, else print “”
|
| Format data Sheet size? | 24 Jul 2006 14:08 GMT | 4 |
I am working in Excel 2007 (beta) I have created my sheet and was able to remove sheets 2 & 3 which I don't need. I would like to trim the size of the sheet and only print the contents of my
|
| create a thin border around the selected cells | 24 Jul 2006 13:53 GMT | 1 |
need information on excel 2003
|
| Easier way to re-connect Data Import | 24 Jul 2006 09:03 GMT | 2 |
I have set up a SS which is connected to an Access MDB file. (Data/Import Data/ Data Query) It sits out on the network and is copied to the C Drive on each workstation to use. The MDB is on a Shared Data drive - drive G: My new boss just happens to have different Network ...
|
| Need to compute values in 2 column's | 24 Jul 2006 05:30 GMT | 3 |
Hello; I am a National Guard technician and I'm trying to determine the following; I have several different types of equipment from different states. I
|
| League Table using Index | 24 Jul 2006 03:52 GMT | 2 |
I've had a quick look around to see if this sort of question had been asked before and couldn't find anything similar. I'm fairly new to Excel and am trying to construct a footbal league table with matches matches for 6 teams. So I have a array of the 6
|