When I click on the column heading the column doesn't look highlighted. It's really annoying when I'm doing a find and cant see where it is due to it not...

When I use functions in Excel, arguments are differentiated by ; For example =sumif(range;criteria;sum_range) I want to use , instead of ; Where can I...

it function on office2003, upgraded to 2007 with lot of unhappy

Hi, I would like to calculate the hours between two columns: First Contact (G) and Appointment (H) with (m/d/yyyy) h:m AM/PM) format. First Contact (G) ...

I have an aplication called DPlot that can take commands from inside excel using macros. I managed to interact already with it using the following: - Sub...

Hello: Here's my array: A B C 1 Band Service Target 2 6 SAP 95% 3 7 SAP 96% 4 8 ...

I have absolute references set up to access data from a different sheet in the same workbook. When I insert new columns in the data source sheet, the...

I was using conditional formatting, but this only gives three options, I need 5 I am looking for a simple piece of code which says If cell A1 is not zero...

I'm trying my hand in UDFs. In practice I created the following UDF in a module Function Area(Length As Double, Width As Double) Area = Length *...

Hello, I have an application called DPlot that can take commands from excel through a macro. I managed to pass information like so: - Sub...

Cell data: 15-Feb REG 22-Feb REG 8-Mar REG 15-Mar REG 15-Mar REG 29-Mar APIN 29-Mar REG 29-Mar REG 29-Mar REG

How do I insert a button into a spreadsheet that will "clear" all values from cells that are intended for inputting data, but not clear other cells that are...

Hi, I have a column with times in it 11:28:46 AM 11:29:21 AM 11:29:50 AM 11:44:03 AM 11:44:10 AM 11:44:25 AM

Dear, I am working on a macro which trims the raw data into a desired one. i would require your help in adding the macro code to delete the entire row if it...

This could be very simple, but I will lay the groundwork first. I have a schedule spreadsheet that I import data to from a web based program. There are...

I have a fairly big table that provides values for a pivot table. I would like to view the data from the pivot table and copy and paste this information to...

There are 2 of us that use the same Excel Workbook. We are all using Excel 2003. When I check the widths of the columns in the Worksheet, they are...

I need to rank a column containing concatonated names and addresses. Ranking only handles numeric values, is there any way to give text a numeric value?

I have been trying to rectify the anomalies in the data in a spreadsheet that has become a mishmash of different Project and Task codes in order to provide a...

Hi All, I've got a webpage with a drop down menu which provides links to various Excel And Word documents. It works extremely well with Word but when you...