Can I use hyper link in one cell but link to more than one external data files? If not, how can it be done?

I have added several check boxes to a form. Now I would like to change the font and increase its size. When I right click on the box, I do not find such an...

Hi I need a formula to count cells in one column containing dates depending on the contents of a differnt column like SumIf has the option

i just created a pivot table and he first row shows an empty row then the second showed data in it why so any help.

I need count values, crossing rows when match in columns values.

I am trying to ascertain if there is a method by which I can cause text/information on a worksheet to expand, and thereby fill the entire page (print preview...

I am using a procedure that saves password-protected a 2007 excel file to a folder. when I try to open it I get the message: "excel cannot open the file...

I am writing an Excel 2002 template, and wish to convert a large range of imported data. All of my formulae have been written in row A on a ‘Reformatted...

I get this message when I want to change the colour of a font . I don't understand why . " No more fonts maybe applied to this work book"

Can anyone please advise me how I would write a worksheet selection event code so that when you select a particular worksheet it turns the calculation on and...

Is there a way to copy the hyperlink property only from one cell or column of cells to another? I originally wanted all cells in my rows to have the same...

I am failing to drag or shift cells/rows/columns in my excel worksheet. I have reinstalled MS office XP ,but it did not help me. What should I do?

I have a lot of code in the form; Sheet4.Range("S" & iCount).Value = Range("B20").Value Sheet4.Range("T" & iCount).Value = Range("C20").Value Sheet4.Range("U"...

This is in XL2003. I'm trying to make a simple in-cell graphic that visualizes a percentage created by two other cells. Here's the formula in cell...

Hi, I have a set of pivot tables which are being updated by cell the date in cell B1 using the following...

in joining the MVP Club. Micky

I have a table of values for 5 different geographical areas. I want a formula that will look at 4 of the areas and compare it to the value of the 5th. If any...

i need to be able to stop people using a macro twice on the same spreadsheet untill another macro is used and then allow them to use the first one...

trying to deploy a vb.net dll to clients; on some machines the following run-time error occurs: Unable to case COM object of type...

HI Can somebody help me urgently. I am looking for a template concerning surety as i cannot find anything on Office templates. Tx.