I have 11 macros in an excell 2000 spreadsheet. I would like to be able to run the macros in different cells. Is this possible and if so, how do I set this...

Chitra, Run this small macro and you can unhide ~ALL~ your worksheets quickly. If you want to pick and choose, then I suspect you need a utility program...

I am running a program with information that changes several times during the day. There are several rows that need to be counted, but that number changes...

I am trying to format a sheet with cells like 000-00- 0000. I need ti to read 000000000. I have tried everthing in the format cell menu, please help??

Margaret, You can replace "Dir " (excluding quotes). In essence, by leaving a space after Dir, you should avoid your conflict. The same applies to Ave. ...

hi i have some text copied into the cells on my spreadsheet the text is in the format: "textextextext textextextexte

I am running a program with information that changes several times during the day. There are several rows that need to be counted, but that number changes...

I have found that putting the count formulas above the dataset is much better, since you can set the formula to look down to 50000 rows, even though your data...

I have a formula that has a square root attached to it eg: DF=(0.345 x N (square root symbol over the N)) + (0.027 x N). Could someone possibly help me...

I saw someone do this a couple of weeks ago, so maybe someone can tell me how it's done. I have the following information: cars trucks vans average...

Hi all, I have a worksheet with data that I need to protect but also have a number of row and column groups I'd like the user to be able to reveal/access. ...

I am trying to find a formula that will calculate ages in one column based on a birthdate entered into a previous column on a worksheet, that will update on a...

I'm having problems with the following formula: =IF(A2=$C$2:$C$438,B2-$D$2:$D$438) It works fine until the values in column C are not in the identical row as...

Have you tried your proposed formula? ISTEXT will fail if the cell contains an error value like #NA()! so you should be able to just expand the range to the...

does anyone know if you can refer to more than one array in a single Excel statement? I can't find any references in Excel help or textbooks saying I...

Does anyone know if it is possible to paste links and transpose data simultaneously? Thanks in advance.

Hi, I've read through various articles regarding this topic and have tried the following...

It has been a long time since I asked this question to this problem. The answer was simple but I forgot what it was. I have a template spreadsheet I created...

I have 12 workbooks that each contain a worksheet for each day of each month (thus, up to 31 worksheets for each month for each workbook). I have a 13th...

HI, How do I get rid of the zero? Basically, this particular spreadsheet has some cells that are linked to cells in another worksheet, and since there is no...