This code gives the correct number of Rows and Columns being used in my worksheet:- Dim x As Worksheet Set x = Worksheets("Store") Debug.Print...

I have an worksheet that requires extensive manual data entry. Human nature says people will make keying errors. I'm looking for a safe guard. If b3 is...

Hello I hve some code that inserts 4 lines into a spreadsheet one at a time Is there a line of code that would permit me to put in 4 lines in one go? Many...

Needing to produce a formula that counts cells that provide a result that is 0 but 3, AND also only those that are shaded Orange in addition to the values....

Nothing here answeres my question so I was hoping someone could help. For example I have a cell that uses lookup formulas to grab a performance indicator...

hi, I have a -0.02 difference with the following function when it should be 0 =(e57-e62)*5.73 4.73-4.73 *5.73 The only thing that can think be causing...

can somone please assist me what formula I can use to find the missing in a sequence number? see example below. How could I find the missing 1327, 1330...

Hi all, I am wondering if there is a way to hide parts of a pivot tables subtotals. I have data in numerical form and percentage form. For the numerical...

Hi All, done it before where I highlight & copy my spreadsheet from Excel 2007 & paste it directly into my gmail page without any problem. But when I tried to...

Hi, I have a budgeting program which allows the export of the data in Excel format. I get the error File or assembly name Microsoft.Office.Interop.Excel, or...

I'm hoping someone can save me alot of work and aggrevation. I have a list of cities in alphabetical order in column A and in column B a list of the bus...

I need cells to automatically adjust to fit text entered. This text will be entered by others after I complete the workbook. Thanks for your help!

Dear All, I have a weight matrix and a function matrix. The function matrix value are to be chosen from a set of archived data, in such a way that for a...

I am trying to have an independent cell show one of three icons: up arrow, sideways arrow or a down arrow based upon a formula. This would be example...

I am trying to search data from between various sheets of a single workbook but my results are not quite what I expected. I have a single workbook in which I...

I created drop down list and would now like to add to the contents. How do I do this?

I have a 390 page Excel 2007 spreadsheet. On the first page I have links to the other 389 pages. On each of those 389 pages is a link back to page 1. Is it...

I need to have any text entered into a cell automatically changed to all captials. Is that possible? If so can someone please send the steps. Thank you --...

Happy New Year to all This Formula in conditional format only works in Respect to C10. I am trying to achieve that if a number is placed in any of these...

I am using Excel 2007. How do you establish traditional cell solid borders for workbooks (the same as what all previous versions of Excel would print)? Now...