| Thread | Last Post | Replies |
|
| Macro Installation! | 28 Oct 2004 18:26 GMT | 1 |
I know excel quite a bit , currently am using Excel 2003 but i dont know if get a Macro code built in VBA, i wish to know how do i run it? i know i have to paste the code in a module but what to do after that? should i save it or just return to excel?
|
| Why is #### coming up to hyde one of the numbers in a cell I am f. | 28 Oct 2004 17:59 GMT | 1 |
Please help - All of the sudden #### comes up when I mobe on to formulat a value in excell.
|
| Save workbook as a Text file | 28 Oct 2004 17:17 GMT | 8 |
I have recorded a macro to store an Excel workbook as a .* txt file. The result from the macro-recorder is mentioned below --------------------------------------------------------------------------------- ActiveWorkbook. SaveAs Filename:="C:\Temp\map1.txt", _
|
| Referencing a date as text | 28 Oct 2004 16:59 GMT | 3 |
In sheet 1 of a spreadsheet I use there is a cell that gives the current date as "MMM-YY" ("Oct-04", for example). In the second sheet I refer to this cell with the formula {=Sheet1!A1}, which gives me the date. What I want to do is
|
| Check for updated cell | 28 Oct 2004 16:27 GMT | 1 |
Hello! Is it possible to check for an updated cell or range cell? Thank you very much in advance.
|
| Can a Hyperlink copy a file? | 28 Oct 2004 16:23 GMT | 1 |
Is it possible in a hyperlink, to make it first copy a file to a new location and then open the new copy?
|
| bookmarlkelt and reloading | 28 Oct 2004 16:16 GMT | 1 |
javascript:void(document.title=prompt("Rename title:")); the above bookmarklet is extremely useful. But if I lcik reload I have to again operate the bookmarklet. where am I doing wrong??
|
| CSVDE Dates in Excel | 28 Oct 2004 15:16 GMT | 4 |
How do I convert the Active Directory formatted dates exported by CSVDE when viewing in Excel to a readable format?
|
| Can Someone Help? | 28 Oct 2004 14:39 GMT | 2 |
OK...IM TRYING TO GET MY WORKBOOK TO SAVE DATA..THEN RESET THE DATA O THE FIRST OF EVERY MONTH...NOT SURE IF THIS IS POSSBLE...BUT ANY INF WOULD BE APPRECIATED....THANX :confused --
|
| Multi-Row Sheet tabs | 28 Oct 2004 14:03 GMT | 1 |
Is it possible to have the Sheet tabs displaying as Multi-Row? ie rather than having to scroll Left - Right to view one row of 30 tabs, is it possible to display them as 3 rows of 10 tabs? Excel 2002 sp1
|
| incremenT CountIF Value | 28 Oct 2004 14:02 GMT | 2 |
i'm not sure i've expressed my problem clearly. say in column A i have the values 1,2,3,4 and 5 so it may run like this 5
|
| Export XLS to TXT will Comma separator | 28 Oct 2004 13:58 GMT | 1 |
I'd like to export/save Excel file into a text file. The result I wan is something like this, OWNER,ROOMNUMBER,TELNUMBER,DEPARTMEN instead of like this when saving in Text (MS-DOS), CSV (MS-DOS) etc,
|
| Can't start excel | 28 Oct 2004 12:29 GMT | 2 |
Hope someone can help me on this. I can't start my excel program as it keeps prompting me to install the CD...however I have misplace the CD and can't find it. Thanks!
|
| how can i add a pecentage on to a total | 28 Oct 2004 09:42 GMT | 3 |
I NEED TO ADD A PERCENTAGE TO A TOTAL COST TO TAKE THE FINAL FIGURE FROM COST PRICE TO RETAIL PRICE
|
| Print multiple sheets in one print job | 28 Oct 2004 09:07 GMT | 4 |
I want to print several worksheets (e.g. sheet1, sheet 4, and sheet5) in one print job. This is a frequent task for users of one spreadsheet and would be much more convenient for them. I could probably write a macro to print each sheet individually, but it would be nice to print ...
|