Microsoft Excel

• Microsoft Excel Questions

• • zoom in &zoom out in VBA User Form

    Can anyone tell me how to make a Zoom in/Zoom out control by usingexcel VBA user form?And also, when...

    By youu917_gmail_com

  • Zip and mail more than one sheet from the ActiveWo...

    Hi Ron,Yes please post an example. I tried to combine two VBA examples on your website but was not s...

    By martin

  • zip code entry

    I saw a couple of other posts regarding the problem with the zeros not displaying properly in zip co...

    By anonymous

  • Zip and mail more than one sheet from the ActiveWo...

    Hi Ron, Yes please post an example. I tried to combine two VBA examples on your web site but was not...

    By anonymous

  • zipcode merge problem

    When I do mailmerge for labels with Word, a few of my zipcodes are there (randomly) but most are not...

    By anonymous

• • Zeros on the left

    Hi, have check number such as 00356. When entered in a cell and pressing enter, it shows 356. How ca...

    By anonymous, 6 Comments

  • Zip workbook

    Hi,Can someone help me create a code that zip, send and thanmail (attached the zipped file) workbook...

    By john, 7 Comments

  • ZIP Code insanity - , How to…vlookup, formats, num...

    What is the deal with Excel and ZIP codes, I know a lot of people out thereare using Excel for addre...

    By doug929, 3 Comments

  • Frustrated with Microsoft

    Application.SendKeys "%n" & CellContents, True The above part of the following code does not functio...

    By anonymous, 2 Comments

  • Zip codes and Excel - Please Help!

    Here is my issue: I have 19k zip codes in excel. They where sent withou the 0's to me. So many ...

    By anonymous, 5 Comments

• Microsoft Excel: is the Category's subject.It's has 495,234 questions,this is No.24,762 pages.
• - Need Help Finding Duplicate Customers
• Hello Everyone,I have two customer lists with a names and customer numbers. They arecurrenlty in the same spreadsheet. I'd like to create a list ofduplicate customers who have the same customer number. One list hasover 10,000 customers. The other list only has a few hundred.How do I find the...
• marywei, Fri, 19 Mar 2010 03:46:00 GMT, 455 bytes, 1 Answer
• Yr to Yr comparisons
• After years of being in a high level tech support position, I transferred to a Business Analyst position. I forgot the formula used to provide the percentage increase or decrease this year compared to last year. 2003 2004 1,200,359 2,529,259 What is the percent increase in sales from 2003 to 200...
• anonymous, Fri, 19 Mar 2010 02:50:00 GMT, 515 bytes, 3 Answer
• Zoom problem
• In the below code, I get a Run-time error:'1004', "Unable to set the Zoom property of the window class." The intent here is to insure the window is sized to 54% when the "Metrics" worksheet is selected by the macro. What do I need to do to fix this? Sub GoToMetric1() 'GoToMetricA1...
• anonymous, Fri, 19 Mar 2010 02:46:00 GMT, 577 bytes, 2 Answer
• Zip codes are not formatting
• I am trying to do a mail merge using an excel data source of addresses. The zip codes appear with zeroes in the data source, but when I merge them to MS Word, the zeroes are dropped. How do I fix this problem?...
• anonymous, Fri, 19 Mar 2010 02:45:00 GMT, 217 bytes, 1 Answer
• -- operator
• Hi, Quick question really... I wanted to 'countif ' with several criteria and found the following on the mr excel boards: =SUMPRODUCT(--(B1:B1000="Chris"),--(C1:C1000="working"),-- (D1:D1000="laptop")) (it counts the rows which have Chris working with a laptop). It worked really well,...
• anonymous, Fri, 19 Mar 2010 02:25:00 GMT, 553 bytes, 4 Answer
• zip code entry
• I saw a couple of other posts regarding the problem with the zeros not displaying properly in zip code entries. I'm able to see the zeros, but when i try to mail merge the zeros are there but the rest of the zip code dissapears. Or if I don't format the cell as text, then the zeros don...
• anonymous, Fri, 19 Mar 2010 02:02:00 GMT, 451 bytes, 1 Answer
• where does PERSONAL.XLS go
• Where should the file PERSONAL.xls-which contains the macros- be located to ensure that it is started every time Excel is fired up Thanks -- Norton Professional 2004 says this email is clean...believe it...
• anonymous, Fri, 19 Mar 2010 01:57:00 GMT, 223 bytes, 1 Answer
• Zoom property
• Please you know why setting the Window.Zoom property can have no effect on an activedocumenthost? Thnak you....
• anonymous, Fri, 19 Mar 2010 01:29:00 GMT, 120 bytes, 1 Answer
• Adding to a named range on another worksheet
• I hope I can relay my problem cleary I have 2 worksheets, the first sheet is a form where the user answers a few questions and inputs a lot of data. It looks something like this 104-89-78 MARTIN 02/04/2004 02/01/2004 DEBORA 07-55-20 LEWI 111-21-56 HAMPTO Etc.. Where I am having problems is havin...
• anonymous, Fri, 19 Mar 2010 01:23:00 GMT, 865 bytes, 1 Answer
• YTD to appear in the Charts
• Hi, My WB contains many Charts linked to many tables etc. Every month I update them in order to get an YearTo Date situation. A remark I got from a user is that in the chart is not evident which month I'm referring to, (although it's YTD, during a presentation it would be better to see...
• anonymous, Fri, 19 Mar 2010 01:17:00 GMT, 734 bytes, 4 Answer
• Zeros
• I need my zero (0) to show. Example: I put in 24.950 (tons) and when I click enter, it changes to 24.95. How can I get it to leave the zero (0) in?...
• anonymous, Fri, 19 Mar 2010 00:48:00 GMT, 151 bytes, 2 Answer
• Zeros
• I need to place a Zero in front of a number, but when i press enter, it goes away, how can i keep it there'?...
• anonymous, Fri, 19 Mar 2010 00:47:00 GMT, 117 bytes, 2 Answer
• Zip and mail more than one sheet from the ActiveWorkbook
• Hi everybody, I have used Ron's (de Bruin) web page quite a lot and found it very, very useful. Normally I am able to amend his code into exactly what I need. But this time I am struggling. In VBA I am trying to "Zip and mail more than one sheet from the ActiveWorkbook". Any help much appre...
• anonymous, Fri, 19 Mar 2010 00:12:00 GMT, 366 bytes, 4 Answer
• adding time zones to formatting
• Is there a way to add a time zone to an auto-format? For instance, I have a sheet that enters the current time into a particular cell when a command button is activated but my users are in different time zones across the U.S., any suggestions?...
• anonymous, Thurs, 18 Mar 2010 23:39:00 GMT, 255 bytes
• Adding to a range of cells for validation from a cell
• I am an Excel novice so please be patient!My problem is this-I have a drop down list set up in D2 in worksheet 1 which references a listof customers contained in column A in worksheet 2. When the selection ismadein D1, sheet 1 it returns a contract number in E2 from column B in sheet 2using VLOO...
• markdullingham, Thurs, 18 Mar 2010 23:06:00 GMT, 1,811 bytes, 7 Answer
• Zip and Hide arrow keys(+reverse)
• I have been working on a spreadsheet given to me that can hide multiple columns and rows by clicking on an arrow key located in the margins of the sheet. How can I program this into other spreadsheets I develop as this does not appear to be a function on standard Excel 2002?. Is there any add in...
• anonymous, Thurs, 18 Mar 2010 23:02:00 GMT, 409 bytes, 2 Answer
• Zero(0) values box checked-but not displayed as a 1st digit ?
• I am working on a spreadsheet in Excel, however I can not get the zero(0) to display in the cell as a first digit of a number. Example: 0319 is displayed as 319. I checked the zero values box under Tools, Options, View and that did not work....
• anonymous, Thurs, 18 Mar 2010 22:23:00 GMT, 257 bytes, 3 Answer
• adding times
• I have a list of minutes and seconds eg, 5:33 (five minutes, 33 secondes). I would like to add them together but am not having any luck. Anyone know how to do this?...
• anonymous, Thurs, 18 Mar 2010 21:57:00 GMT, 172 bytes, 3 Answer
• Zero's
• I am doing a report where 0 is the first number in the cell, but not for every cell. So they look like this: 094521463 456245654 654621327 When I try to format it to put a hyphen between the 2 and 3rd numbers the 0 erases. Is there a formula that would allow me to change all the 9 digit numbers...
• anonymous, Thurs, 18 Mar 2010 20:28:00 GMT, 770 bytes, 2 Answer
• Adding text to an Activecell
• Hi there...Need help!! I am writing some code whereby once I know which cell is the current ActiveCell, I have to add a timestamp value to the cell which I am getting as follows. Application.ActiveCell.Value = Format(Date) Now my trouble is that this statement is overwriting the existing informa...
• anonymous, Thurs, 18 Mar 2010 19:10:00 GMT, 750 bytes, 2 Answer
• «««247542475524756247572475824759247602476124762