| Thread | Last Post | Replies |
|
| Colour cells | 11 Dec 2006 13:11 GMT | 2 |
Is there a formula which will colour cells.(Not conditional format) want to say that if cell A1 = B1 then cell f12 will turn green. Possible --
|
| Excel 2002, is there a custom zoom level? | 11 Dec 2006 11:40 GMT | 2 |
So far, using Excel 2002, the zoom settings I've seem give me either 75% or 100% (plus others) but nothing in between. Is there a way to adjust the spreadsheet size to 80% or 90%? When I try the Selection choice the zoom goes to 319%, sometimes 400%, and when I click on the ...
|
| Scraping Meta Tags | 11 Dec 2006 05:14 GMT | 1 |
Hi everyone, Im trying to find a way to get meta tags into my sheet, Im using IE.document.Title to get it in and it works fine, but does anyone have any examples of how to get in other tags, such as keywords, or descriptions etc..
|
| Sorting | 11 Dec 2006 04:03 GMT | 2 |
I have a problem sorting in Excel. When I try to sort my list in Excel it sorts like this: 1.1.1 1.1.11
|
| Floating button | 11 Dec 2006 03:51 GMT | 3 |
On sheet one I have a large number of entries that are all hyperlinked to somewhere on sheet two On sheet two I have a button that when clicked returns me to sheet one. The problem is that when I click on a hyperlink one sheet, I do go to the
|
| show number as KB or GB | 11 Dec 2006 02:03 GMT | 3 |
How can I format a column so that it shows a number as kilobytes or gigabytes? Thanks.
|
| Using lookup with wildcard | 11 Dec 2006 00:04 GMT | 2 |
I am new to excel, and wish to know how I can use Excel lookup with wildcard? I have a number of devices that people call by different names but there is a word that is common to all - "domain" For example :
|
| Reference Grouped Objects Using VBA | 10 Dec 2006 22:10 GMT | 5 |
I have grouped four charts, three text boxes (from the control toolbox) and a rectangle. Prior to grouping, the code I had to update the axes on both charts and text for the text boxes worked fine. After grouping the objects the code fails.
|
| How do I remove the _#wvu#FilterData stuff ? | 10 Dec 2006 21:55 GMT | 2 |
Hi I have an Excel file which has inside *a lot* (hundreds) of items like: Name1$Z_13EA6EA6_0D7A_423E_AD8B_413AEC2C108A_#wvu#FilterData Name2$Z_5031E0F8_BE3B_4523_B36B_78DD8D6B5CE2_#wvu#FilterData
|
| Count amount of different dates & amounts of them. | 10 Dec 2006 20:22 GMT | 3 |
Is this really a new user group :-) I guess I'm a slow learner :-( Hi, I have a column with Dates from the current Month, in non sequential
|
| Cells: Any way to code an event behind one? | 10 Dec 2006 19:47 GMT | 4 |
I'm thinking I'd like to automatically select the next cell in a series after the user pastes something into the current cell. Can I write event code for a given cell, like "Cell(2,3).AfterUpdate()"?
|
| Is there a way to limit access to a page in Excel to one person? | 10 Dec 2006 19:14 GMT | 1 |
Is there a way to limit who has access to a page created in Excel to only the people who need to have the access? Like perhaps to put a block on it?? Or fix it so that you have to have a password to gain access to the particular page??
|
| Import file from mainframe | 10 Dec 2006 18:29 GMT | 7 |
I am looking for a solution for import a file from mainframe to excel do you have a solution
|
| hiding large ammount of columns in excel | 10 Dec 2006 17:15 GMT | 1 |
i have 2 pc's with excel 2000sp1 the OS is winxp pro sp2 the systems have a lot of free space in hdd and ram 512 or 1024 when i try hide few columns there is no problem..
|
| Avoiding .Select and .ActiveSheet | 10 Dec 2006 15:52 GMT | 6 |
I'm in the home stretch on rooting out/replacing all my .Selects and .ActiveSheets with direct object references. Two last situations that I can't figure out to handle: 1) How to grab a range that includes all cells in
|