"Zargon_osu" wrote in message ... I have a column with many data...

I have a problem when I use the "Save As" Method of the MS Excel Application object from within Visual Basic. All operations of opening, manipulation of cells...

I have a mailing list with name, address, city, state & zip with each item in individual rows like a list of labels and a few empty rows of space between each...

If row 1 containes your column headers, try this formula in cell A2 (I assume your column 1) and copy it down thru all the rows you wish to use it. Let me...

when i use the function ACCRINT(),I meet a...

I have imported a large amount of data into excel from a proprietary software platform, unfortunatly I have only be able to do so in a way that leaves a...

Hello All, (Excel 2000) If I have a sheet and use auto filter, I will would like to be able sum, average etc... it's results without fixing the cell...

A worksheeet function cannot make any changes to the worksheet, other than returning a value to the calling cell. -- Vasant "Gauss"...

I have inserted a picture on top of a worksheet, turned it into a watermark, now I need to have the gridlines show over the watermark. How do I do...

Is it possible to set up excel that as a default it will only print only the pages where information has changed? Thanks, Wendy

I have a list of data in workbook 1, for example: a list from 1 to 10 each with a number value next to it. i want to export the values to a cell in another...

I have a workbook that has so far 6 worksheets. On every worksheet but the first I would like to calculate year-to-date totals for about 4 different cells. ...

I'm attempting to insert the path along with the filename in a footer in Excel. Inserting the filename is easy but I'm stumped as to how to get the path...

Hi, Does anyone know how I can set an invoice up (in word or excel) so that linked or hidden are "product lines" (eg product code, item description and cost)....

Hello, I am trying to use CHIINV function in Excel (I have Excel 2002). The help guide says that the degrees_of_freedom could be as high as 10^10. But as...

How can I display a formual in a cell without switching on the display formulas option in tools, options. ( I need to show the actuall formula in the cell, not...

I am using countif statement to identify an occurence. The problem is that I need the actual qty which is in a different column. How would I sum a column only...

I've struggled with this so hope you can help... I am trying to create a new Table A from an existing one, Table B. Table B. Column A = Products, Column B =...

I would like to print a 2 column sign-in sheet that extends over 2 pages but only uses about 30% of the print area on each page, on 1 page. In other words, is...

I'm importing into Excel a column of data that represents 4-digit phone extensions. The range is from 1111-9999, sorted from top to bottom. Not every number...