Good afternoon, all, I have a scroll bar on a worksheet that, which when I right click and click "Format Control" displays a dialog box with "Size",...

Can someone help me understand this function's syntax? Here's the situation: I have a workbook with a dozen tabs. I want to create a thirteenth tab, called...

I have a formula in a cell (F17) that calculates the following: =B14/36 Easy enough, it's just a normal formula. However, I would like the result to come out...

Thank you to who ever suggested this site http://www.xldynamic.com/source/xld.SUMPRODUCT.html But I am still unclear on which unary or operator to use, ,--,...

I wrote code intended to evaluate and reassign the value of a named range based on an "on change" worksheet event. The code changes the named range value when...

We have a user that encounters a problem every time he uses subtotaling in Excel 2003 (w/SP2). Even though he has Calculation set to “Manual�, every time...

2003 Had thoughts of compiling some Excel VBA into a ..dll file. I thought that I needed just AppSentinel. But it appears that I need VB or something...

So I managed to create a spiffy dialog box which has a bunch of buttons which run a bunch of macros. But the dialog box is stuck in a tab called...

Is it possible to easily round up from 9/15/06 to 10/1/06? Thanks in advance for the help.

How do I get excel to automatically count the number of rows with data in them and insert the row number in a colum. I don't want to count any blank rows.

Is there a faster way to hyperlink in excel 2003 other that Help/Microsoft Excel Help/Create a link between cells in the same worksheet or workbook I have (1)...

Hello I have a List in which I can filter vertically for a certain entry, but then I would like to be able to filter horizontally in the way that I just want...

I have a problem in that I use a spreadsheet which uses automatic calculation. When I open the spreadsheet it calculates automatically but every now and again...

I have code to open a workbook at a specific worksheet. This works great! I still want to be able to do this along with being able to open any other...

What is the formula for counting the number of cells containing ANY text?

I have several spreadsheets that I put together for other people to enter data and report results. The sheets are made of about 25 sets with four rows in each...

Hi, I have a list of over 6,000 staff records in column A, with a date of birth in the format dd.mm.yyyy against each record (in column B). I have been asked...

Has anyone got any impressive excel add ons- in code format preferable to add to my system?? anything at all is fine- i just want to see what will look...

Excel 2003. I programmatically protect each sheet in a workbook as I programmatically create the sheets. Moreover, I enable only the unlocked cells in the...

Okay, I know how to say "When a cell equals nothing" (="", or =0), but how would I say "When a cell equals something", whether a letter, symbol, number......