Is there a way to determine the last active column in a spreadsheet?

611

---

My stop recording toolbar has disappeared. How do I get it back?

602

---

I want to count the number of cells in a range that have a particular interior color. The countif function seems like the right kind of answer but how to I return thecolor of the interior for each cell in a range? I would like to do something like: =countif(b1:b10, cell("interior","red"))?

588

---

I have a column of numbers in the format 99999-99999. What is a simple macro to remove the dash?

643

---

I have a list of 3215 product names on a spreadsheet. Each resides in a single cell. I need to put each name in quotes. The names are all in one column?

594

---

I have created some clever formulas, and I don not want anyone else to see them. Is it possible to hide the formulas but display the results?

718

---

Excel uses for the indirect and address functions or formulas?

616

---

Somehow, my worksheet has external links to files that are no longer around. How can I delete the links?

681

---

What is pure botany? What is applied botany?

1084

---

What are the reserve food materials in pheophyceae?

1219

---

Explain steps involved in transcription?

971

---

Why do you use dbm instead of ncf in the northern blotting and what are the pre-treatments required for this paper to be used?

1067

---

How to calculate protein percentage in lowry method?

1063

---

Dubai is desert, how it is possible it is becoming greenery?

1107

---

What is the difference between defined, characterized and standard serum?

1201

---