| Thread | Last Post | Replies |
|
| table within cell | 24 Apr 2007 22:08 GMT | 1 |
Can a table be placed inside a cell? A B C 1 cat mouse horse 2 dog A B C pig
|
| Excel prints page as tiny little square | 24 Apr 2007 21:18 GMT | 3 |
Someone sent me an Excel spreadsheet and half of the tabs are ok, but half print as a tiny one-inch square somewhere on the page. How do I fix this? P -
|
| concatenate data problem | 24 Apr 2007 20:30 GMT | 3 |
I have the following formula =CONCATENATE(B13,AY13,"-",C13,"-",D13,"-",E13,IF(F13="","","-"&G13&AY13&"/"&F13)) to return the following text 2.5"-MS-1302-01CS-1SW-2.5"/ST
|
| Mapping network drive... | 24 Apr 2007 20:21 GMT | 2 |
Is there a way to map a network drive in a macro?
|
| running some VBA code in response to data entered in a cell | 24 Apr 2007 19:50 GMT | 2 |
hello again Can anyone tell me if it is possible to trigger some VBA code when a number entered in a particular cell on a worksheet is less than the number in another cell?. I dont know if cells have events linked to them such as mouse
|
| Toolbars with diff versions of Excel | 24 Apr 2007 19:20 GMT | 7 |
I have a customized toolbar in Excel 2003 and want to use the same customization in Excel 2000 without ahving to do everything rom scratch. Is the 2003 XLB file compatible with the Excel 2000. Or is there a way to export/import between versions?
|
| File opening help | 24 Apr 2007 18:58 GMT | 4 |
I have 2 files that I created last week (spent a lot of time on them also) and for some reason they wont open. Excel asks if I want to update links and then doesnt do anything. It looks like the file is open as when I go into explorer I cant move it - but in excel its just not ...
|
| Conditional Format | 24 Apr 2007 18:28 GMT | 2 |
I have one column that contains condtional formatting as the following: =today()-D2>=90 Should the field meet the above condition then the text would turn red as the format but even though it was applied to the entire column, each date
|
| Help with entering text in a macro. | 24 Apr 2007 16:52 GMT | 4 |
As part of an existing macro I want to add quite a lot of text in rows 1 to 13. The way I am achieving this is using:- ActiveSheet.Cells(1, 1).Value = "insert text here to appear in row 1 column 1, the value of cell A15 is”
|
| Conditional formatting, "0" not equal to blank | 24 Apr 2007 16:41 GMT | 3 |
I would like the following conditional formatting A blank cell = no filling 0 to 0.99 = red 1 to 1.99 = yellow
|
| Find & replace on multiple worksheets | 24 Apr 2007 16:22 GMT | 5 |
I have multiple worksheets in my file. How can I use find and replace over all of them instead of going into each individual worksheet? Thanks much!
|
| how to look up the value in another sheet | 24 Apr 2007 14:54 GMT | 1 |
I have one input sheet use to add data to another sheet(Database). The input sheet is like a checklist. In the input sheet, I have one combox box to select the tool id. Since each tool will have its own spec for each inspection (upper
|
| video | 24 Apr 2007 14:11 GMT | 4 |
I'm not sure if I'm posting in the right place...anyway. When I want to watch a streaming video the video will pause, I assume to allow more data to be "loaded". How can I avoid that. I wouldn't mind waiting as long as I can view the entire video without a pause.
|
| How to start a macro with pivot-chart-update-button (!) | 24 Apr 2007 13:45 GMT | 4 |
Hey Guys The pivot-chart-update-button (!) dominates my custom pivot-chart- layout. This annoys me (and I get no credit from my colleges as Excel- expert). The chart is placed in a chart-sheet.
|
| IsNumeric with array or range | 24 Apr 2007 13:29 GMT | 4 |
I want to check a list of cells to be sure they're all numbers before performing a computation on them. Is there a quick way (as opposed to looping through all the cells) to check? I could set the cells up as either an array or range but IsNumeric doesn't seem to work on either ...
|