| Thread | Last Post | Replies |
|
| Hyperlinks Turning Them OFF! | 07 Apr 2004 04:31 GMT | 5 |
I have been unable to find out where and how to have excel turn off the Auto hyperlink feature when web address and email address are typed into excel. Any help would be appreciated in this matter...
|
| Warning note in excrll 2000 | 07 Apr 2004 03:31 GMT | 2 |
Hi to All I have in Excel 2000 (office 2000 Pro) hyperlinks to WordPad files & mp3 files, all of them in the same computer.
|
| Variable column widths | 06 Apr 2004 23:22 GMT | 3 |
How can I change the column width for certain sections of my worksheet? for example: i have three separate tables on a worksheet using the same columns. I need two of the columns to have a different column width than the first. please help!!
|
| Saving Excel 2000 In RTF | 06 Apr 2004 23:20 GMT | 3 |
Does anyone know if there is a way to save Excel 2000 in a Rich Text Format?
|
| Function to sort/order horizontally? | 06 Apr 2004 23:17 GMT | 2 |
I know I can select data and sort and order it vertically by row data. But can I select data and sort it into an order by columns? I have lines charts based on data that was dumped in kind of haphazardly. The X-axis points are set by the values in row 2 across each column - but ...
|
| Nursing Scheduling workbook | 06 Apr 2004 22:49 GMT | 6 |
Hi - not sure if this is the best place to post this, but here goes. I'm using Excel 2000. I have been asked by my wife, who has responsibility for this, to look at a pre-existing workbook whose object is to schedule nurses and technicians in a 70+ bed nursing facility, for ...
|
| Newbie - help needed with lookup, please. | 06 Apr 2004 22:39 GMT | 7 |
Hi - help needed please. I need a way to read a text string from one cell (say Sheet1A1), find it in a list in another sheet (say Sheet2 A17), then copy a numeric value from a cell alongside the found cell (Sheet2 B17, say) into another cell on the first sheet (Sheet1B1, say). If ...
|
| Reinitialize a RANGE object in VBA | 06 Apr 2004 22:27 GMT | 1 |
Hi, again...now another question I would like to write a function: Public Function NetPV(CashFlows As Range, drate As Double, period As Integer) As Variant All I need is the ability to change the contents of the Range array, CashFlows depending on the
|
| Passing Cell values to a SQL statement | 06 Apr 2004 22:11 GMT | 3 |
I have set up a spreadsheet that uses excel's "Get external data" feature to connect to a SQL database and run a querry. The problem is that I need to get data for several different product codes. These codes change from time to time but basically the querry looks like
|
| Excel error: Permission to use object denied | 06 Apr 2004 20:58 GMT | 2 |
I have some new computers setup with Windows XP and Office 97. When go into Excel and open a spreadsheet, I get a Microsoft Visual Basi error:Permission to use object denied. The spreadsheet will not open. The error happens with every spreadsheet I try to open on tha
|
| Newspaper Columns | 06 Apr 2004 20:32 GMT | 5 |
I have a long list of data consisting of three narrow columns. When I print the sheet, I'd like to repeat the set of three columns a few times per page (exactly like a telephone book) to prevent wasting paper. Can't find how to do this in the help index. Any suggestions?? thanks ...
|
| Fitting Line to Exponential Data | 06 Apr 2004 20:11 GMT | 3 |
I should be able to do this but can't figure it out in Excel. I want to fit a line to some nonlinear data so I can project intermediate points. I gather I need the LOGEST function for this but I'm not able to make it work.
|
| How can I insert an existing form into a spreadsheet | 06 Apr 2004 18:52 GMT | 1 |
I am using Excel 2002 SP2 on WinXP. I have a government form in pdf format that I am required to fill out and submit each month. The data is summarised in an excel spreadsheet and I copy the figures by hand to the form. How can I insert the pdf form into the spreadsheet so that I ...
|
| sorting/filtering a list into columns | 06 Apr 2004 17:10 GMT | 1 |
I'm nearing the end of a project (an email game) and i would like to have the sheet keep scores. So far, I have 2,3,4 players and these are represented by columns B,C or B,C,D or B,C,D,E. (depending on which you select.) Player 1 takes
|
| Macro help - formula showing #DIV/0! | 06 Apr 2004 16:37 GMT | 4 |
I've created a macro that inserts a formula in my current cell and then formats the result. The macro looks like this: ActiveCell.FormulaR1C1 = "=COUNT(C[1])/COUNT(A:A)" ActiveCell.Select
|