I have used the following Macros from the Discussoion Group in Excel 2007 to supress printing of Row 1 to 5. Private Sub Workbook_BeforePrint(Cancel As...

As a teacher I use randbetween to generate class register numbers when choosing children for special assignments which, as 7 year olds, they can see is the...

I format cell using "Warp Text" to have my text within my cell width. However, the height of the cell remain same resulted bottom line within cell unable to...

Our head office, in their wisdom, moved our network drive from F: to H:. Now I can't make any changes to ToolsOptions..., because anytime I click on a tab,...

= IF(Condition,G14*b,"") where b is a constant named on another sheet, Starting with this formula,, How does one ensure that the cell reference "G14" remains...

Help! This IS something that I was able to do some time ago, but it has been a long time! I have sales for each day in ten different categories (listed 1 to...

Hi I am trying to insert Bitmap as OLE object in Excel 2003. I am doing following - Insert-Object-Create from File-Browse (to select the image)- tick...

Hi I have 2 list array in the following collumns (both list are not sorted) Array 1: A - list of city names B -list of language Array2: C - list of city...

I have 3 ranges 1. week number 2. Rep code 3. Product value how do i count the number of weeks that pertain to a specific rep code i.e countif rep code...

I have four columns of information: 1) Latitude of the boat location 2) Longitude of the boat location 3) Distance of an animal from the boat 4) Bearing of the...

I have just been a presentation done by someone external to my organisation. As part of the presentation I was shown a template which had features I wanted...

Does Microsoft sell a product that will allow me to draw multi-colored bars in a gradiated fashion similiar to a progress bar?

I love working with styles, of which I've built up quite a few handy ones over the years (They accumulate in my always-hidden "Personal" workbook). However,...

This is an absolute nightmare. I know that you typically use a different program but all my process flows have been stored in Excel. Editing them has...

Dear Masters, How to get value of max from array with some condition? for example I have data : A 3 B 3 A 5 C 2

I have to use Excel 97 for a project I am working on. When I insert a page break into the spreadsheet nothing happens. It is as though the inserted page...

I have a form into which I want to load values from a list. I have three forms on one page. How can I load the forms from the list and have the forms...

i have a worksheet with locked columns containing formulas. how can i insert rows & copy the formula above without having to unprotect the worksheet?

hello :) I have an access database that maintains master information on all CSRs in my department, their production, and their errors. I am trying to bring...

I'm trying to use SubTotals on filtered data using SumProduct. The data is on a different worksheet 'WGS_F3", I want to be able to use a filter on the WGS_F3...