Search results for query: *

Thanks Loomah, But it only works on a brand new workbook (or worksheet). I tried to work it in one of my existing workbooks which already has about 25 worksheets and it does not work. Anything I should know? Hope I am not taking up too much of your time, but I simply don't know how VB works.

I have formatted certain cells of my spreadsheet to indicate time in the format hh:mm using the custom cell formattihg option. With this method, everytime I enter a time say 19:30, I have to insert a colon using the shift key and all. Is there a way by which I can simply type in the four...

I have formatted certain cells of my spreadsheet to indicate time in the format hh:mm using the custom cell formattihg option. With this method, everytime I enter a time say 19:30, I have to insert a colon using the shift key and all. Is there a way by which I can simply type in the four...

Thanks Brad, It worked. Ofcourse I'll have to go through your explanation a few times before I can get a grasp on it, but the imnportant thing is that it worked for now. Thanks again and have a nice day.

Well Brad, I am not a very advanced Excel user. So, I replaced 'filename' with the actual filename, 'Sheet' with 'Sheet1' and 'A1' with 'D5' in your suggestion above and pasted it on Sheet2 of my workbook. Nothing happened. Infact the cell turned into '#value'. So, can you please be a bit...

I have 10 sheets in my Excel workbook. In cell D5 on sheet1, I have the number 1. If I want that number to increase by 1 in cell D5 on sheet2, what formular should I use in cell D5 in sheet2? The obvious answer would be: =Sheet1!D5+1 But if I copy that formula on to sheet3, cell D5 on...

So this gradient script, can it be worked only with the BODY tag or can it also be worked with other tags e.g. TABLE tag. I tried to give a table a gradient background using this script, but did not succeed. Any hints?

...= document.createElement('div')); aDiv.style.height = bandHeight + 'px'; aDiv.style.top = (bandHeight * bandLoop) + 'px'; aDiv.style.backgroundColor = 'rgb(' + colourSteps[bandLoop][0] + ',' + colourSteps[bandLoop][1] + ',' +...

I have a directory full of Excel files. All the files are of the same format. I want to look for a file (spreadsheet) that has the number (not text) 9.543 in cell D10. Is there a search utility that allows me to do something like that? I can't seem to do it with conventional search utilities.

Thanks Dan, I took your script and converted into a simple two colour gradient. Have a nice day.

I would like my web page to have a gradient background. Now I did a search and came up with the famous Background Fader Script. However, this script has an animation between many colours. What I want is a simple steady gradient between two colours. No animation, no fancy stuff. I can't seem to...

Thanks Tony, I see it now. Regards.

In MS Office 97, I could protect one section of the Word Document, while leaving the other section free to be edited. I am ofcourse talking about protection for forms. In MS Word 2003, they have changed the complete dialogue box for protection and I cannot find any way that I can protect one...

Thanks Skip, It worked. Have a nice day.

I have formatted a few cells in my spreadsheet to wrap the text within them. My question is: Is it possible to break lines (like make paragraphs) in that cell? Or do I have to make do with one paragraph.

Many Thanks macropod. It worked. You have just saved the day. Best Regards.

Thanks macropod, it did work. Now what do I do if I want to add the same cells as: =A1+A2+A3+A4+A5. What do I do then? I tried to use =(IF(ISERROR(A1+A2+A3+A4+A5),0,A1+A2+A3+A4+A5)) but it didn't work. This is the way I really want to do it. I think I asked the wrong question in the first...

I have some numbers and some uncalculated formulas as follows: A1: 123 A2: 567 A3: #VALUE! A4: 856 A5: #DIV/0! Now, I want to add them all up by using the sum formula =SUM(A1:A5) but I want to add only the valid numbers (123, 567 and 856) and ignore the uncalculated formulas (#VALUE! and...

I don't know about you guys, but if the middle name was blank, I would have forced a middle name with something really wierd like "555abc" and then gone with the original code. When the time came to read the data, the "555abc" could be replaced with "". Very amateurish, but a heck of a lot...

Well, I tried lots of combinations and here is what worked atlast: $text =~ s/(\r\n)+$//; $text =~ s/\n/<br>/g; $text =~ s/\r//g; The first line did not do it by itself, the first and second lines did not do it by themselves. I had to introduce the third line to get it working. Thanks...