| Thread | Last Post | Replies |
|
| * in sql instruction | 26 Feb 2008 11:05 GMT | 2 |
I'm trying to do a sql instruction to bring data from access, but I don ´t know why it doesn't work: Dim xlsht3 As Excel.Worksheet Dim crit_customer As String
|
| cusor locked | 26 Feb 2008 07:46 GMT | 2 |
I dont know if I bumped a key or what but now when I try to move the cursor from one cell to the other the whole page moves instead of the cursor, how do I fix this
|
| Random Number Question | 26 Feb 2008 06:04 GMT | 4 |
Does anyone have a Random Number Formula for creating the following Random Numbers in 52 different cells with no number repeated Yes I am working on a Poker Rally and need to generate score cards that are different and Random
|
| "Locking" Question Regarding Excel 2007 | 26 Feb 2008 04:34 GMT | 2 |
I have a sinking feeling that the answer to my question will be no, but here goes anyway: Is it possible to "lock" (or group) a block of rows (and blocks of rows throughout the spreadsheet) so that
|
| Moving worksheets to new workbook | 26 Feb 2008 03:33 GMT | 3 |
I have a workbook with multiple worksheets. Each worksheet tracks activity for a specific item during a period of time. Upon completion of recording the activity during the tracking period, I need to move the worksheet, for that specific item, from that workbook, to a different ...
|
| page scroll | 26 Feb 2008 01:43 GMT | 3 |
I dont know if I bumped a key or what but now when I try to move the cursor from one cell to the other the whole page moves instead of the cursor, how do I fix this
|
| no decimal point if zero | 26 Feb 2008 00:02 GMT | 19 |
I need to restrict the data entered into a cell as below: 0 = 0 1.0 = 1 1.10 = 1.1
|
| Reduce Size of Blank Rows | 25 Feb 2008 22:25 GMT | 6 |
I am using Excel 2007, and I have a column that contains many blank rows. These blank rows are all 16-point in size, and I want to reduce all of them to 8-point or even lower in order to tighten up the appearance. Is there any way I can do this automatically (and without sorting ...
|
| Stripping digits from a column | 25 Feb 2008 20:03 GMT | 2 |
I've a column containing alphanumeric text as 200731705A832565410B12345678. Out of this text, I need only the 9 right most digits. How do I go by? TIA,
|
| Can't clear cell of "object" copied/ pasted from web page | 25 Feb 2008 19:59 GMT | 2 |
I pasted some text from a web page into a cell in a speadsheet. But when I copied from the web page I must have copied a check box that was near the text, so that got pasted as well. Thing is, I can't get rid of it. I've tried to clear the contents of the cell, but only the ...
|
| Help with xlsx files | 25 Feb 2008 19:16 GMT | 1 |
I am still using 97Office Excel. My customer sent me excel files in xlsx format this morning. I could not open those xlsx files. I now downloaded the converter for xlsx to xls format.
|
| How to tell if a cell is protected | 25 Feb 2008 18:49 GMT | 4 |
I have nine workbooks I have combined into one workbook using the drag-and-drop system as described by Bernard Liengme on 11/25/07. All the workbooks were single worksheet's that my company uses as forms for personnel files. I don't want to reinvent the wheel, but I am trying ...
|
| Formula needed please... | 25 Feb 2008 18:39 GMT | 8 |
I need a formula that will do the following: If a letter entered into cell A1 is the same as the letter already in cell A10 then change the text colour in A10. Is this possible?
|
| Macro to add name on a cell based on the data | 25 Feb 2008 16:41 GMT | 2 |
I am using Excel 2003 and I need help to do a macro. I copy and paste data into a worksheet call "Table" In the worksheet I want to put a specialist name in the column called "Specialist" beside a column called "STATE" the specialist name will be based on what the state is. ...
|
| macro Copy and paste from one worksheet to another | 25 Feb 2008 16:41 GMT | 2 |
I am using Excel 2003 within the workbook I have a worksheet call "Detail" I want to copy and paste selected data to another worksheet called "Exhibit A" or "Exhibit B" based on data from a cell. Name Type Exhibit
|