| Thread | Last Post | Replies |
|
| Get first blank cell | 29 Jan 2005 21:27 GMT | 7 |
I would like to get the number of the row with a blank in a certain column. I was trying something like this: {=IF(ISBLANK(<range>),ROW(<range>),0)} but that's not working. Can I do this without resorting to a macro?
|
| Programming | 29 Jan 2005 21:17 GMT | 1 |
I have a problem. I want to write a program using VB in Excel. I put a txtbox and a cmdbutton in my worksheet. When I click on cmdButton, I want my program to do this:
|
| webQuery with stock quotes: single cell, not multiple cells | 29 Jan 2005 21:08 GMT | 4 |
Via Yahoo I am trying to get stock quotes into my Excel worksheet: So via goto A1, select Data->Get External Data->New Web Query and use e.g. http://finance.yahoo.com/d/quotes.csv?s=EBAY&f=sl
|
| Help with Diet | 29 Jan 2005 21:05 GMT | 3 |
I am on a diet and would like to make a spreadsheet to help track my progress. I weigh in every morning and I now have about one month’s worth of data, so I am anxious to get started – the problem is that I know almost nothing about Excel. I have bought a book, Show Me, which ...
|
| need to import or convert Works.wdb file into Excel 2000 | 29 Jan 2005 21:01 GMT | 1 |
I need to import a Works.wdb file into Excel. I have Office 2000 small business. I don't have Access. Is there a way to open or convert this .wdb file into Excel 2000?
|
| Gordon. Yes f9 worked.How come not automaticly? | 29 Jan 2005 19:02 GMT | 1 |
Using Excel Spreadsheets My running sum at the bottem of page Changes automaticly When I enter new numbers on some sheets but I have to do it all over on others. Yes F9 worked but why is it not auto. Y
|
| Sub gives error I don't know how to fix.... | 29 Jan 2005 16:46 GMT | 8 |
This sub, which gives a "Run-time error '13': Type mismatch", is meant to put overtime for a 2-week period in the BB column, for all rows that have an X in the AT column. Hours for the 2 weeks are in AW and AX, and overtime is anything over 40 for each week. I cannot figure out ...
|
| VB coding to clear a selection? | 29 Jan 2005 14:34 GMT | 8 |
I currently have the selection clear by changing the cursor location to cell D2 (Range("D2").Select). So if the entire sheet had all the cells selected, this would clear the selection but would also move to another location. I actually need the active cell to remain the same
|
| Finding sheets | 29 Jan 2005 14:30 GMT | 3 |
I'm just an inquisitive person, I guess ;-) I would like to create the name of a particular sheet dynamically, then read data from it. For example, ="'"&MONTH(A1)&"."&DAY(A1)&"."&TEXT(MOD(YEAR(A1),100),"00")&"-"&MONTH(B1)
|
| How do I create a grading system in Office Excel? | 29 Jan 2005 14:29 GMT | 1 |
Many teachers use computers to build their grading policy and generate the grades that their students get for each semester. Can I do this in Excel? If so, how is this done?
|
| Copy Formatting to new worksheet? | 29 Jan 2005 14:20 GMT | 1 |
I would suspect the answer to this is no but just by chance is there anyway to copy all the formatting of a worksheet to a new worksheet without any of the data. Copy just colors, column widths, etc. Would come in handy for importing CSV data and then quickly formatting to a ...
|
| How do I change office assistant in Excel 2002 | 29 Jan 2005 13:46 GMT | 1 |
How do I change office assistant in Excel 2002
|
| Validation - help me pls | 29 Jan 2005 13:31 GMT | 3 |
With validation you get an arrow for a pull down, when you are standing in the cell. If you not standing in this cell you do not know there is a pulldown menu. Does one of you know if it is possible that the arrow is shown everytime.
|
| Can i run VB code when a user changes Worksheets within an Excel Workbook | 29 Jan 2005 13:20 GMT | 1 |
I have a Excel Spreadsheet with 6 worksheets in it The first sheet contains all the data and the other sheets do various things with the data (graphs etc) On the first sheet i have buttons above some of the table colums which
|
| velocity=Distance/time | 29 Jan 2005 13:11 GMT | 2 |
I want to obtain velocity of a vehicle by dividing distance(ordinary number format) to time(time format of 00:00) by the formula: velocity=distance (km)/Time(minute). And alternatively transfer it to Km/hour unit. Divding numbers by 00:00 format requires special command which I have
|