Home » Category » Microsoft Excel

Microsoft Excel

• Clearing data from one worksheet to another

• I am looking to build a sheet that will act as a "front page". It wil request some information from the user, numbers and text only. I want this data to be transferred to a particular row address (i.e A5, A8 and A10) in another sheet, where all the calculations an formulae are all set up. The da...
• Thu, 29 Jul 2010 06:30:00 GMT | 900 bytes | Answers (1)

• VBA Efficiency Question

• The function below works perfectly, but it is very slow for large tables. I can obviously achieve the same result more efficiently with an array formula, but the syntax of this function is more intuitive and much easier for my end-users to utilize. Any thoughts on how to speed up this function?...
• Thu, 29 Jul 2010 04:30:00 GMT | 654 bytes | Answers (4)

• Hide Workbooks

• Hi there,I was working with Macros, and storing themin "Personal.xls". I made some mistakes, and tried todelete the macros, but the error message said I couldn'tin a "hidden" workbook. I "unhid" the worksheet, deletedthe bad macro, but now I can't "Hide" the workbook again.What do I have...
• Thu, 29 Jul 2010 02:30:00 GMT | 413 bytes | Answers (2)

• HOW TO: capture the event when a row group is expanded or collapse

• Hi TWIMC I have rows 10 to 19 grouped and the grouping is collapsed. In cell (B20) I have a function that reviews the rows(Index).ShowDetail so when collapsed it returns the text "more..." thus when I expand the row group and show all the rows, the return text in cell B20 will read "hide..." but...
• Thu, 29 Jul 2010 02:30:00 GMT | 677 bytes

• Histogram Bins Created From Sum Of Two Cells

• I'm trying to model patient flow delays through a receptionist and a nurse to see a doctor. I've got a two dimentional array, with the distribution of delays created by a receptionist across the top, and those created by nursing preparation down the side. In each cell, I have the perce...
• Thu, 29 Jul 2010 00:30:00 GMT | 1,433 bytes | Answers (3)

• Counting Unique Values

• Hiya, Cells D1:D14 contain values Numerical & Text, and may appear more than once in this range, I would like a way to count cells with values (ignoring blank cells) and ignoring duplicate values, the result to be displayed in D15, VBA or Formula. I've attemped to search around the discussi...
• Thu, 29 Jul 2010 00:30:00 GMT | 400 bytes | Answers (9)

• How to convert Conditional Format into the "real" format?

• Hi, does anybody know the trick to easily convert Conditional Formatting into the "real" cell format? (don't need to have conditional format anymore) Thanks...
• Wed, 28 Jul 2010 21:30:00 GMT | 173 bytes | Answers (4)

• PROPER function in a colum

• I have imported a list of manes and addresses for customer data base - when they were entered they were not consistient in their application of capitals and small case - before I import them into a mail merge I need to put in proper format - I can't seem to get it to work with the help insi...
• Wed, 28 Jul 2010 20:30:00 GMT | 345 bytes | Answers (2)

• option buttons help

• hi..im need 2 add 2 option buttons.. i have 2 cells that are for placeing a persons name ( to eliminate and error due to misspelling of a name)..i want to place 2 option buttons ..and place that persons name in the cell and use the option button instead of haveing the name typed in Thanks in Adv...
• Wed, 28 Jul 2010 20:30:00 GMT | 316 bytes | Answers (2)

• code to identify matching text

• I have a spreadsheet containing mainly text. I wish to go down the sheet starting at row 2 and concatenate the cells in column b,c,d,e,f (adding a space in between each into the cell) into column M until it reaches a row when both cells E & F are empty. Then starting at the top to go down the li...
• Wed, 28 Jul 2010 20:30:00 GMT | 855 bytes

• Compare 2 lists

• Is there a native way in Excel to compare List1 and List2 and find out whichrecords are missing between them?Up to now I have imported the information into Access and done an unmatchedquery.Windows 2000 OSMS Office 2000Dave French...
• Wed, 28 Jul 2010 20:30:00 GMT | 270 bytes | Answers (1)

• Copying headers and footers between sheets

• Is this possible? User has a workbook with multiple sheets already set up. They want to copy the header and footer from one of the sheets to all other sheets. I'd like to set it up so that it prompts them for the sheet with the h/f to be copied and then asks which other sheet(s) to copy it...
• Wed, 28 Jul 2010 17:30:00 GMT | 468 bytes | Answers (2)

• Microsoft Excel Questions...

• Please, i need this function to return formula to cell...not the value but the formula... thanks a lot Public Function fnMonth(i As Integer) fnMonth = "=Podklady!B" & 114 + i End Functio -- kontra - kontraa's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3302 View t...
• Wed, 28 Jul 2010 17:30:00 GMT | 415 bytes | Answers (2)

• How to make a particula cell ACTIVE using C#

• I am using Excel Spreadsheet Active X control. In my application, I wouldlike to restrict the user from entering anything but numbers in a column.When he enters an invalid input (not a number), I display an error messagebox. I want that cell to retain the foucs. At present, it is moving to thene...
• Wed, 28 Jul 2010 17:30:00 GMT | 430 bytes

• why my columns in excel are no longer alphabetized?

• My columsn are numbered. They are no longer alphabetized. I am using excel 2007 and I have no idea why this has happened. Please help....
• Wed, 28 Jul 2010 16:30:00 GMT | 138 bytes | Answers (5)

• Excel will not delete the tmp files.

• Since I have upgraded to Office Service PAck 2 for Office 2003, excel has quite deleting the .tmp files that it creates when you open a spreadsheet. How can I fix this. I have tried turning off auto save but the setting changes back each time I edit a new spreadsheet....
• Wed, 28 Jul 2010 15:30:00 GMT | 280 bytes | Answers (1)

• Toggle change control button face id & caption

• The following code toggles a command button turning on & off an inpu range. Need VBA code to that would change the face id & caption of th command button when the input range goes on & toggle back when th input ranges goes off. Any ideas? Dim INPUTRANGE Sub Auto_Open() 'BEGIN INPUTMACROTOGG...
• Wed, 28 Jul 2010 15:30:00 GMT | 589 bytes | Answers (1)

• Given a Row and a Column I would like the Range reference

• I'm inserting a custom user defined function into a cell. As a parameter to the function is a cell which is the cell in which the function is located i.e. in cell A5 I have the following function =myCustomFunction(A5) Now, I want to insert this function automatically into that cell but the...
• Wed, 28 Jul 2010 13:30:00 GMT | 578 bytes | Answers (5)

• Help Please

• What i want to do is really simple.I have column B with 50 numbers. I want to set up column C so that inC2, if B2=B1 and then it returns a value or something like false. Itreally doesn't matter what it returns though.Then in C3, if B3=B2 OR B3=B1 then it returns the false valueThen in C4, if...
• Wed, 28 Jul 2010 12:30:00 GMT | 694 bytes | Answers (3)

• Unable to save workbook within WorkbookBeforeClose

• Hi, I'm trying to save the current workbook within the WorkbookBeforeClose but the file is not saving. The WorkbookBeforeClose is an application level event in my com addi with the following signatur Private Sub mExcel_WorkbookBeforeClose(ByVal Wb As Excel.Workbook Cancel As Boolean) If Not...
• Wed, 28 Jul 2010 12:30:00 GMT | 665 bytes | Answers (2)