Column width: Font characters?!? not inches?

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Excel
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Pivot Chart problems This is a multi-part message in MIME format. ------=_NextPart_000_00B3_01C4E370.755D7D40 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable I have two issues with pivot charts. 1) I create a pivot table and chart with VB. I want thick lines on the = chart, so I do as follows: For i =3D 1 To .SeriesCollection.Count .SeriesCollection(i).Select With Selection.Border .Weight =3D xlThick End With Next This works great. However, upon selecting a Page Field value from the = drop down created automatically on the chart, the new version of the = chart has thin lines. Is there a way to tell Excel to create thick = lines as a default? 2) I want the pivot chart to use a time scale. If I use the following = line: .Axes(xlCategory, xlPrimary).CategoryType =3D xlTimeScale I receive the following message: "Invalid procedure call or argument". = If I use this same code on a chart created from a table, I receive no = message and it works fine. There must be some problem using pivot = charts that I don't understand. Harley ------=_NextPart_000_00B3_01C4E370.755D7D40 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Dwindows-1252"> <META content=3D"MSHTML 6.00.2900.2523" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT size=3D2>I have two issues with pivot charts.</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>1) I create a pivot table and chart with VB.  I = want=20 thick lines on the chart, so I do as follows:</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>        For i =3D = 1 To=20 .SeriesCollection.Count<BR>       &nbs= p;   =20 .SeriesCollection(i).Select<BR>       =     =20 With=20 Selection.Border<BR>        &nbsp= ;      =20 .Weight =3D=20 xlThick<BR>          &n= bsp;=20 End With<BR>         = Next</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>This works great.  However, upon selecting a = Page Field=20 value from the drop down created automatically on the chart, the new = version of=20 the chart has thin lines.  Is there a way to tell Excel to create = thick=20 lines as a default?</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>2) I want the pivot chart to use a time scale.  = If I use=20 the following line:</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT=20 size=3D2>          &nbs= p;=20 .Axes(xlCategory, xlPrimary).CategoryType =3D = xlTimeScale<BR></FONT></DIV> <DIV><FONT size=3D2>I receive the following message: </FONT><FONT = size=3D2>"Invalid=20 procedure call or argument".  If I use this same code on a chart = created=20 from a table, I receive no message and it works fine.  There must = be some=20 problem using pivot charts that I don't understand.</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>  Harley</FONT></DIV></BODY></HTML> ------=_NextPart_000_00B3_01C4E370.755D7D40-- Tag: Column width: Font characters?!? not inches? Tag: 51412
  - 2
    - Needed: A Quick Integration Routine Hi All, I offten want to get an integrated average value of some time / temperature data. Time is usually in col 1 and temps are in the other columns. I'd like to select an arbitrary period of time /temperatures points and find the intgrated average temperature value. Does someone have a good way of doing this, perferably with worksheet functions but some VBA code would also work ? Thanks, Mike Tag: Column width: Font characters?!? not inches? Tag: 51407
  - 3
    - Securing Workbooks Gang: I would like to secure my Excel 97 (and Excel 2000) workbook from users in such a way that they can only enter values in a specific range and view the results in another range. I'd like to keep my formulas and other sheets hidden from the users. I;'ve been using the Protection properties at the range, sheet, and workbook level. Unfortunately, as soon as the user saves the workbook using the Save As method, it appears that all protection is removed. Do anyone have any suggestions on how to keep the sheets and workbook protected when the workbook is saved as another object? TIA, Ed Tag: Column width: Font characters?!? not inches? Tag: 51403
  - 4
    - radio button on protected worksheet Is there a way to create a set of radio buttons within a password protected template so that the "Cell or Chart you are trying to change is protected..." error does not occur when selected by the end user? I want my template to be locked, but I want the users that use the template to be able to select either RadioButtonA or RadioButtonB. Help? Tag: Column width: Font characters?!? not inches? Tag: 51402
  - 5
    - Splitting a Cell Hello, I have a Cell that contains first and last name data. I would like to split this one cell into two cells, one with first name data and one with last name data. I have tried doing this through a Macro, but with no sucess. Can anyone point me in the right direction? Thank you! Tag: Column width: Font characters?!? not inches? Tag: 51401
  - 6
    - unable to copy to all, i cannot copy data from excel file to another files, no matter it's an excel or word file. i can ONLY copy and paste data from worksheet accross worksheet within the same excel file. Please help!! Thanks calvin Tag: Column width: Font characters?!? not inches? Tag: 51396
  - 7
    - Hide too long text in a cell How can I hide the part of the text that is too long for the cell? This automaticly happens when in the cell on the right is already a text. But I want this also when there is no text in the neighbouring cell. (Note: I don't want to use wrap text) Tag: Column width: Font characters?!? not inches? Tag: 51394
  - 8
    - how to stop program in a big loop Hi, everyone Right now I wanna do a time-comsuming loop in excel programming, for example: for i = 0 to 100000 for j = 0 to 10000 'my parts doEevents next next during run time, I still wanna use a "Cancel" button to let user have choice to stop it during run time? how to do it, Pls advice Tag: Column width: Font characters?!? not inches? Tag: 51391
  - 9
    - Web Query I am currently running a macro that initiates a web query on a https site that contains mixed content (both secure and non secure items) the query keeps failing because the warning message "This site contains both secure and non secure items. Do you want to display the non secure items?" prevents the query from proceeding. Any ideas on a work around? Is there a way to turn the warning messages off I have tried adjusting settings in IE however this does not appear to turn the warning message off in excel. Could a command be written into the macro to click yes at the point of the warning message? Any help appreciated. Thanks Reo Tag: Column width: Font characters?!? not inches? Tag: 51384
  - 10
    - ???: Freezing data at a set time I am ingesting real-time temperature data into excel. I want to know what the temperature was at certain times of the day. How do I get the computer to save the temperature every hour but also keep importing and monitoring the current temperature ? Thanks, Grinch Tag: Column width: Font characters?!? not inches? Tag: 51383
  - 11
    - Making sound with Excel Can Excel make sound ? I am ingesting real-time data into excel. When certain criteria are met, I want the computer to ring an alarm or play a sound file. How can I do this? I'm good with Excel and do macros but don't know vba at all. Thanks, Grinch Tag: Column width: Font characters?!? not inches? Tag: 51381
  - 12
    - Saving data to Jpeg or gif I'm trying to save a large block of Excel data as an image file. I have tried copying the data and pasting into "Paint" and then saving as an image. This works...but some data disappears in the strangest way. Very strange. All of the data gets copied but some is missing when you look at the image. Does anybody know a simple way to save Excel data as an image ? Thanks, Grinch Tag: Column width: Font characters?!? not inches? Tag: 51380
  - 13
    - Excel Formulas I am trying to creat a logical test and at the end have it round up the result. Here is my formula so far: =IF(ISERROR(D50/E3),0,D50/E3) . This will prevent me from getting the dreaded #DIV/0! but I cannot get it to round up the result. The idea is to keep it contained within that particular cell. Any help would be greatly appreciated. Thanks. Tag: Column width: Font characters?!? not inches? Tag: 51365
  - 14
    - Convert text to numbers Hi I have a column of numbers in text format - I need to change them to number format When I goto Format ->cells to change - it does not work Is there another way to change? Thanks Tag: Column width: Font characters?!? not inches? Tag: 51364
  - 15
    - Question on LABEL Range In a LABEL Range(say that it has 12 elements row-wise), how do one refer to the 4th elements? I have this ideas that in a worksheet, I have 12 rows single column LABELED range called MONTHS, where 1st elements is JAN(that is C6), and so on, and last element would be DEC(C17). How do I get the 4th element which will be APR, and put that value in the different cell using the LABEL reference instead of the absolute cell location(C9)? Thanks Tag: Column width: Font characters?!? not inches? Tag: 51362
  - 16
    - weeks Hi! is there a way of automating the number of weeks based on the now() date? (i.e. 52 weeks/year) Thanks! Tag: Column width: Font characters?!? not inches? Tag: 51355
  - 17
    - Microsoft far better than Google http://wonderfulthings.blogspot.com Tag: Column width: Font characters?!? not inches? Tag: 51354
  - 18
    - Calculation order What order do calculations calculate in? Are the first calculations created in the worksheet always calculated first? If the calculations are in row 1, are they calculated from left to right? If the calculations are in column 1, are they calculated from top to bottom? Any help would be welcome. Tag: Column width: Font characters?!? not inches? Tag: 51352
  - 19
    - vba coding I have a test tool that generates a 1079 row x 13 column csv file and I would like to automate its conversion into a spreadsheet we use to analyze it. The tool takes samples for different areas and has an id# associated with that area in one column. Some areas require two samples, others require ten. I would like to take the row associated with an id# and sum the data in columns 9-13 and place the sum in a column and row on another worksheet. If the next row of data in the csv file has the same id# I'd like to sum the data as before and place it in the next column over. Something like: =IF('import here'!$D1='data conv'!$A4,SUM('import here'!$I1:$M1)) then skip down one row in 'import here' =IF('import here'!$D2='data conv'!$A4,SUM('import here'!$I2:$M2)) On a false condition it needs to increment the sample id# & check the next row down in the 'import here'. Any ideas on how to do this or where I can find a good reference? Tag: Column width: Font characters?!? not inches? Tag: 51344
  - 20
    - function to return "number" of different values that occur ? Hi, Is there an function is Excel that can return the number of different values i.e COLUMNA 1 1 1 1 2 2 3 4 5 6 6 6 6 6 TOTAL = 6 (i.e 6 different values appear) Thanks for any help. Scott Tag: Column width: Font characters?!? not inches? Tag: 51341
  - 21
    - stop update link messages I have a workbook I received (via email) from someone we buy from, I take that workbook and edit it to be able to send individual sheets to my customers. Problem is, original workbook creator has links from other workbooks on his machine When I open the workbook it asks me do I want to update the links. Well I couldn't if I wanted to because I don't have the workbooks its asking about. How do I get rid of these warnings. I want to email my individual worksheets to my customers but I don't want them to see this Update message when it doesn't pertain to them (it's very frustrating). Any help suggestions would be great. Thanks in Advance! -- Kathy F Milwaukee, WI Tag: Column width: Font characters?!? not inches? Tag: 51338
  - 22
    - New Date on each new page I would like to print a page for each day for the upcoming year. 365 pages. I want to print all of them now. On each page I need the date for that day. What should I use for this? Pivot tables?? Thanks! Jim Tag: Column width: Font characters?!? not inches? Tag: 51333
  - 23
    - Print Preview Print Preview takes ages to open up initially, closes ok, opens up ok and then takes ages to close. Windows Professional, Excel 2002. any clues as to how i can overcome this. Cheers Harcon Tag: Column width: Font characters?!? not inches? Tag: 51331
  - 24
    - Excel 2000 zero-size window? Running Excel 2000 under Win98, the standard (non-maximised) Window size seems to have become zero. In other words, when starting Excel either by running excel.exe (from shortcut or directory display) or by clicking on an .XLS file, an entry appears in the taskbar, but no window opens on the screen. Right- clicking on the taskbar entry and clicking Restore does nothing. Clicking Maximize works properly. It is as if the normal window size has become 0 x 0. On trying to Restore the Maximized window, the window disappears again. An alternative description: Excel in what should be a normal window behaves as if minimized. It can be Maximized, but Restore is the same as Minimize. It can be made to work full-screen or not at all. I would be grateful for any idea on what is happening/ Is there a registry entry which governs the current size of the normal window? Best wishes, -- Michael Salem Tag: Column width: Font characters?!? not inches? Tag: 51322
  - 25
    - Trouble with "MatchRequired" in XL visual basic Hi all I have to use the MatchRequired property to limit what can be entered into the spreadsheet via the form I have set up. The problem is that when an entry to put into the form combobox that is not present in the dropdown menu, I get the message "Inval property value". THE PROBLEM(s) The field is not highlighted to display to the user that it is the field they just entered that is wrong, i.e. it does not set focus. The message is not that clear - it sounds too techi for a basic user of XL - can I chnage it ?? If the entry is deleted then it still comes up with the error message even though their is a blank as an option in the dropdown. i.e "" is coded into to reflect a blank - is this different than deleting or backspacing?? Any help appreciated. Aaron Tag: Column width: Font characters?!? not inches? Tag: 51313
- Next
  - 1
    - Large Dimensions rendering in PIVOT Tables issue Hi. I have an OLAP Cube Design <to> Excel Pivot Table rendering issue here. Our fact table is composed of sales transactions from a website. We routinely take a relatively small number (say 10,000) of these transactions and load them into Excel, where we create a PivotTable. (No OLAP used in this portion....just data right well below the 65k rec max loaded into a worksheet from SQL SERVER) Let's say it looks something like this: http://home.comcast.net/~murdockdesign/PivotOlap.jpg (*screenshot of pseudo Pivot table) **Note that we are using the transactionID (TxID) as a dimension. We want to support this kind of report in an OLAP cube so that we can build the same kind of report against much bigger fact tables. (say 1,000,000+ transactions.) The problem we run into is that Analysis Services (and perhaps OLAP in general) doesn't like dimensions that have millions of members, which is what happens when we let TxID be a dimension in our cube, since each TxID is (of course) unique. In our reading, we've seen that it's a bad idea to let dimensions have more that a few thousand members, and one reason stated is because "users can't easily comprehend a report with that many members." However, we don't typically create big reports. We use the other dimensions in the pivot to filter down the result set so that the resulting PivotReport is only a few pages long containing a few hundred TxID's. We've tried using Automatic Grouping on the huge TxID dimension, but it times out when trying to retrieve the Member Count (we have set SQL SERVER TimeOut Property to 0). We are clear on the fact that a large dimension is considered bad design practice, however we have a real business need to render our data in this way. We would appreciate it if anyone could suggest a way of creating this report in Excel against a data set with millions of unique transaction ID's? Thanks! Tag: Column width: Font characters?!? not inches? Tag: 51308
  - 2
    - Rounding Up Is it possible to perform a calculation and have the result rounded up to the next whole number? I don't ever want it rounded down. Tag: Column width: Font characters?!? not inches? Tag: 51293
  - 3
    - Combining comments. Can it be done? Hi I have multiple sheets. If things out of the ordinary happen a note will be left under that date. There is a possiblelity of there being notes on more than one sheet for the same date What I am hoping can be done is that on one page I can combine all the notes that have been done for each date for an easy summary of whats happening. Thanks Tag: Column width: Font characters?!? not inches? Tag: 51290
  - 4
    - shared .xls is locked for editing... We have a "shared" Excel 2000 spreadsheet that various users can access. Whenever one particular user has it open, and another user attempts to open it, it always says that a completely different user (other than who actually has it open) has it open for editing. Today for instance, this particular user I am referring to above had it open ("jnewitt"). Another user ("slockwood") attempted to open the spreadsheet as well using her Win2K terminal services session, and was told that the file was locked for editing by user "slockwood" - the same user who was attempting to open it in the first place. Clearly incorrect reporting by Excel! I made sure she did not have a lock on it at all by checking system resources on teh Win2K server etc... and she did not. I finally discovered who actually did have the file open and it was the "problem" user referred to above. Why would Excel always be reporting the wrong username for this user? Where is Excel actually obtaining the username that has the file open from?? We have had problems with this user before - but only this user!!!. It will never give his username if he has it open - it is always a different username. Usually it shows as "draft4" - a user that does not even exist on our systems any longer!!! This user runs an XP Professional machine (upgraded from WIn98) and logs onto it locally using his username "jnewitt". Like I said earlier, anytime he has a spreadsheet open and another user attempts to open the same one, they always get a message that "user draft4 has it open for editing" - of course draft4 does not even exist as a user - and is not a local user on his machine either. In fact I searched his entire registry for any reference to "draft4" and found none. Somewhere it is buried on the machine and Excel is using it, thinking that draft4 is the logged on user!!! Does anyone have any ideas on this issue or where Excel might be getting this from?? Thanks, Brad Tag: Column width: Font characters?!? not inches? Tag: 51289
  - 5
    - Opening and Excel spreadsheet in IE I have a user who is trying to open a spreadsheet in IE. She clicks on the link and it comes up with a "page cannot be displayed error". I am able to open the spreadsheet just fine. The user is able to save the spreadsheet to her desktop and open it that way and also, if she already has Excel open, she can open the file without a problem. Anyone have any thoughts on this? Tag: Column width: Font characters?!? not inches? Tag: 51286
  - 6
    - Moving Between Worksheets OK, this will probably win the "Dumb Question of the Day" award, but I'm a newbie, so I'll ask anyway. I have an Excel 2002 file that has LOTS of worksheets. I am constantly moving between worksheets, and spend too much time trying to find the right sheet. Is there any way I can add a new worksheet that has nothing but "links" to the actual sheet I'm looking for, maybe something that works like a website link to other web pages? Is there another way or better way to quickly select the right worksheet? Thanks for your help. Tag: Column width: Font characters?!? not inches? Tag: 51284
  - 7
    - Help adding word doc to excel tab? Here is the deal. I have an expense report procedure written in word and the expense report itself is in Excel. Boss loves it and oh by the way can you add the Word procedures document into an Excel tab. My answer was sure and now I have farted around with it way to long. Sure can be humbling when what you though you knew wasn't really known at all. I have tried inserting an object, browsing, and picking the word document. Appears to work but only grabs the 1st page of the word doc. I have tried all sorts of things and I won't even mention most of them because all I manage to get from word and into excel is the 1st page. So I'm hoping some guru will setup and help out this simplton. Thanks in advance Tag: Column width: Font characters?!? not inches? Tag: 51281
  - 8
    - darkening evey other row could someone please tell me an easy way to darken or shade every other row in excel and also how to print it the same way. i know that i can change this line by line, but this is very time consuming. i think im getting old..lol the lines seem to run together as i look across the sheet.....any help would be appreciated Thanks again Happy holidays Keith Thompson Tag: Column width: Font characters?!? not inches? Tag: 51278
  - 9
    - Counting entries across multiple worksheets I'm no Excel whizz as you may be able to tell from this note. But if anyone can help I'd appreciate it. I have 2 columns of data repeated across 5 worksheets (different departments etc, the same columns but different data). What I'm trying to do is create a summary worksheet showing the count of entries across all worksheets where Column1=x and Column2=y. I've tried COUNTIF but it didn;t seem to work. Any suggestions on how to do this ? Is Pivottable the right choice ? Or should I use Access ? Regards Dave Tag: Column width: Font characters?!? not inches? Tag: 51277
  - 10
    - The chart that was not there I once opened a large xls file, and plotted the data in it. On close it said that the chart is too big and will be truncated. I said OK. Since then on certain OTHER xls files which are much smaller and have NO chart on them, on close and save I get the SAME message, and it always comes up twice. The size of the file also seems to be quite a bit bigger than they should be. Is that chart fromthe first file somehow stuck and hidden in these other files? How can I check and/or get rid of it. Thanks, Ernesto Tag: Column width: Font characters?!? not inches? Tag: 51276
  - 11
    - Cutting and pasting annoyance I frequently copy large amounts of data in msexcel. So often I get the warning that the amount on clipbaord is too large to keep. Is there a way to turn this off in: properties, registry, whatever... I would be happy if it always assumed that it is ok to dump the clipboard contents. Tag: Column width: Font characters?!? not inches? Tag: 51275
  - 12
    - Can I have more than 256 columns on my spreadsheet? I'm very much a newbie to excel. I'd like to setup a spreadsheet with more than 256 columns. Can this be done? If so, how? Tag: Column width: Font characters?!? not inches? Tag: 51271
  - 13
    - Calculate in Today's Money? I have a spreadsheet that lists the estimated balance in a savings plan each year for the next 25 years. I also have estimated the rate of inflation at 3.5%. Can anyone tell me what formula I would use to display the balance in "today's money"? Thanks! Rick B Tag: Column width: Font characters?!? not inches? Tag: 51258
  - 14
    - Determin ing the number of business day in a given month Good day to all of you! Could anyone provide some help in the following area: - I would like to calculate the number of business days within a given month for a given year. I have the month in A1 (format "Dec-04") I would like to put the number of business days in A2 based on the value of A1 (all days except Saturday / sundays) Has anyone done such calculation ? If yes, thanks for sharing the formula! Happy holidays to all of you Tag: Column width: Font characters?!? not inches? Tag: 51257
  - 15
    - personl.xls (storage of VBA-Code) Hello everybody, I had you reinstall EXCEL and can't find the place any more, where I define the storage place for VBA-code and macro-code. I'd like to put everything in personl.xls, but where can I turn that option on? thanks for your help! Walter Tag: Column width: Font characters?!? not inches? Tag: 51252
  - 16
    - Problem while mailmerging with an Excel datasource This is a multi-part message in MIME format. ------=_NextPart_000_0012_01C4E1D2.928EF280 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi everybody, is there a known issue when trying to mailmerge in WORD with an Excel = datasource when the merged EXCEL columns contain formulas. Everything works fine, except that WORD doesn't respect the format = settings defined in Excel. For example, a value (63,24) in a column defined in EXCEL as NUMBER - = decimal places 2 shows up in the mailmerged WORD document as = 63,236249999999998 We work with WORD 2002 SP-3 and EXCEL 2002 SP-3. Thanks in advance for any help. Best regards. Patrick ------=_NextPart_000_0012_01C4E1D2.928EF280 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3D"Courier New" size=3D2>Hi everybody,</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Courier New" size=3D2>is there a known issue when = trying to=20 mailmerge in WORD with an Excel datasource when the merged EXCEL columns = <STRONG>contain formulas</STRONG>.</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2>Everything works fine, except = that WORD=20 doesn't respect the format settings defined in Excel.</FONT></DIV> <DIV><FONT face=3D"Courier New"><FONT size=3D2>For example, a value = (63,24) in=20 a column defined in EXCEL as NUMBER - decimal places 2 shows up in the=20 mailmerged WORD document as <SPAN lang=3DFR=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Times New Roman'; = mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: FR; = mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><SPAN=20 style=3D"mso-field-code: ' MERGEFIELD Rabais '"><SPAN=20 style=3D"mso-no-proof: = yes">63,236249999999998</SPAN></SPAN></SPAN></FONT></FONT></DIV> <DIV><FONT face=3D"Courier New"><FONT size=3D2><SPAN lang=3DFR=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Times New Roman'; = mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: FR; = mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><SPAN=20 style=3D"mso-field-code: ' MERGEFIELD Rabais '"><SPAN=20 style=3D"mso-no-proof: = yes"></SPAN></SPAN></SPAN></FONT></FONT> </DIV> <DIV><FONT><SPAN lang=3DFR=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Times New Roman'; = mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: FR; = mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><SPAN=20 style=3D"mso-field-code: ' MERGEFIELD Rabais '"><SPAN=20 style=3D"mso-no-proof: yes"></SPAN></SPAN></SPAN></FONT><FONT=20 face=3D"Courier New"><SPAN lang=3DFR=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Times New Roman'; = mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: FR; = mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><SPAN=20 style=3D"mso-field-code: ' MERGEFIELD Rabais '"><SPAN = style=3D"mso-no-proof: yes">We=20 work with WORD 2002 SP-3 and EXCEL 2002 = SP-3.</SPAN></SPAN></SPAN></FONT></DIV> <DIV><FONT face=3D"Courier New"><FONT size=3D2><FONT face=3D"Courier = New"=20 size=3D2></FONT></FONT></FONT> </DIV> <DIV><FONT face=3D"Courier New" size=3D2>Thanks in advance for any=20 help.</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Courier New" size=3D2>Best regards.</FONT></DIV> <DIV><FONT face=3D"Courier New" = size=3D2>Patrick</FONT></DIV></BODY></HTML> ------=_NextPart_000_0012_01C4E1D2.928EF280-- Tag: Column width: Font characters?!? not inches? Tag: 51245
  - 17
    - newbie questions I'm new at excel so bear with me. I built a sheet and it has a button i attached some vba code to. Now i cant get back to that code, the button still works ok but i want to add some code beyond what is there First... How do i get back to the code attached to the button? When i do tools/macros/vb editor the code isn't there, nor is the routine listed in either of the procedure drop down boxes. Next... I have a text box, can i set up a formula to put the date/time in the text box (or with a macro) can it refresh on a timer (say once per minute?)? Next... One column in my sheet has date/times in it, i want to color the background of the cells in that column based on certain criteria: A: if the date is the same as today - green B: any other date besides today but earlier than today and only the first instance of that including duplicates - yellow C: always ignore the time in this field and when doing the comparison just use the date. Finally, is there anything resembling a hierarchy of stuff? I mean, some kind of org chart or list showing the methods, properties, and events attached to each item on the tree of excel? ie: what methods properties events etc are part of Worksheet? are part of Cells , Are part of workbook? Are part of a textbox? etc etc, with that it should be easy to browse and figure out what you want to do and at least make an educated guess as to the syntax to use. Without it your just wild ass guessing and drawing only from what you already know without any hope of doing something new. Thanks for your patience, Eric Tag: Column width: Font characters?!? not inches? Tag: 51243
  - 18
    - How do I limit data entry columns? I have 3 columns of data I want to record from a whole pile of bank statements: Date, Amount, Code So, it's a lot of data-entry. How do make the cursor cycle the 3 columns as I am inputing data so that I can just use the ENTER key after entering in these numbers? TIA Tag: Column width: Font characters?!? not inches? Tag: 51237
  - 19
    - Sorting and searching I have no clue if this is possible but I'm giving it a shot :) Everyday, I receive an Excel spreadsheet from one our Escrow companies. The sheet sort of looks like this: Escrow# Lname Fname Comments 1234 Smith Janet blah blah 1235 1243 Jones Susan blah blah 1233 1235 Williams Bill blah blah 1234 1233 Roberts Kathy blah blah 1243 I need to have Excel make it look like this: Escrow# Lname Fname Comments 1233 Roberts Kathy blah blah 1243 1243 Jones Susan blah blah 1233 1234 Smith Janet blah blah 1235 1235 Williams Bill blah blah 1234 I need Excel to recognize the number associaion and move them next to one anoher. The only way I have figured to do this is by using DGET and 3D References across worksheets. Thus far, I'm having trouble. If anyone else has a better solution, please let me know! Thank you in advance :) Tag: Column width: Font characters?!? not inches? Tag: 51226
  - 20
    - problem with custom number format Hello, Win xp and Excel 2003 I am trying to use a customer number format of 17 characters in length 00000000000000000 I can format the colum ok but whenever I enter the data eg 10000000000000001 it changes the last 1 to a zero If I enter for example 10000000000000011 it changes the 2 last 1's to a zero as well. Any ideas? Thanks, td. Tag: Column width: Font characters?!? not inches? Tag: 51216
  - 21
    - deleting rows In microsoft encell 2000 when i delete a row (say row 5) the row disapears but so does the row number then all other rows are moved up is there a way to delete the row and keep the number 5? Tag: Column width: Font characters?!? not inches? Tag: 51202
  - 22
    - WHY why is it that people like Excel so much? I hate it with a passion-- it's like-- my job for the past 4 ot 6 years.. has to been to run around and fix 'excel messes'... automate such and such excel report it's like-- if you guys would just stop using excel-- treat it as a drug-- and start doing stuff in Access-- this world would be a much more efficient world. it's like-- people _never_ have clean data in Excel... there is no validation.. people use it for data entry; and keeping track of stuff-- and it just boggles my mind that people use this POS program for reporting. I mean-- it isn't a reporting tool. It isn't in the same league as Access and Crystal Reports. It's like Access can automate what Excel people do; and then you won't get stuck writing the same report every week. Why don't more poeple hate Excel like I do? I just am frustrated.. because I've seen enough Excel in my life that it makes me sick.. It really is a drug, or a disease.. And when I grow up; and I'm in charge of an IT department.. the first thing that I'm going to do is to Uninstall Excel from _EVERYONE's_ machine and start with the basics. It's all about reusability-- and I dont see excel having any. And I just want to know why is it that poeple think that using Excel for reporting is an acceptable route? It's like a travesty-- 50% of all people in the modern workplace-- all they do is make the same report in Excel; week in and week out. and I don't understand why Microsoft doesn't try to really help these people to use their time more efficiently. It's not about needing sharepoint-- i dont need sharepoint to help me to track my spreadsheets-- that makes the problem worse. Aaron Tag: Column width: Font characters?!? not inches? Tag: 51194
  - 23
    - combining statements Hello Is there a way to use an IF statement to Combine statements from multiple sheets based on a date? Thanks Tag: Column width: Font characters?!? not inches? Tag: 51191
  - 24
    - command missing operand: <identifier> I'm getting the error message "command missing operand: <identifier>" in MS Query when trying to added any group functions like sum or count. Here's the SQL statement that's being generated by Query: SELECT HC_CHARGES.CPT, HC_CHARGES.CPT_CODE, HC_CHARGES.POSTED_DATE, Count(HC_CHARGES.CPT) AS 'Count of CPT', Sum(HC_CHARGES.CHARGE) AS 'Sum of CHARGE' FROM HC_CHARGES HC_CHARGES GROUP BY HC_CHARGES.CPT, HC_CHARGES.CPT_CODE, HC_CHARGES.POSTED_DATE thanks for any help! Matthew Tag: Column width: Font characters?!? not inches? Tag: 51190
  - 25
    - double underline How do I make a double underline that extends accross the cell and not use borders command? I know I can do a double underline while holding down the shift key and clicking on the unerline key but it only underlines the number. Tag: Column width: Font characters?!? not inches? Tag: 51182

All I can find on Column Width is that the measurement I see displayed is
how many characters of the current font will fit across the cell. Is this
correct?!? Is there any way to get the column width in inches?

Ed

Re: Column width: Font characters?!? not inches? by JE

JE
Thu Dec 16 13:26:57 CST 2004

You can in MacXL 2004, but not directly in WinXL.

With WinXL, you can use VBA. For one way, see Ole Erlandson's site:

http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol

In article <#N8g#O64EHA.2568@TK2MSFTNGP11.phx.gbl>,
"Ed" <ed_millis@NO_SPAM.yahoo.com> wrote:

> All I can find on Column Width is that the measurement I see displayed is
> how many characters of the current font will fit across the cell. Is this
> correct?!? Is there any way to get the column width in inches?

Re: Column width: Font characters?!? not inches? by Ed

Ed
Thu Dec 16 14:18:49 CST 2004

Thank you. That looks very promising. Is there a way I can use this to
return the width a column already set in mm?

Ed

"JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
news:jemcgimpsey-291D6A.12265716122004@msnews.microsoft.com...
> You can in MacXL 2004, but not directly in WinXL.
>
> With WinXL, you can use VBA. For one way, see Ole Erlandson's site:
>
> http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol
>
>
>
>
>
> In article <#N8g#O64EHA.2568@TK2MSFTNGP11.phx.gbl>,
> "Ed" <ed_millis@NO_SPAM.yahoo.com> wrote:
>
> > All I can find on Column Width is that the measurement I see displayed
is
> > how many characters of the current font will fit across the cell. Is
this
> > correct?!? Is there any way to get the column width in inches?

Re: Column width: Font characters?!? not inches? by Bill

Bill
Thu Dec 16 17:28:24 CST 2004

Quattro Pro and OpenOffice.org allow you to set column width and row
height directly in inches or metric measurements(not sure if it's cm,
mm, or both).

Perhaps Ole's web site approach is less drastic than this.

Bill

"Ed" <ed_millis@NO_SPAM.yahoo.com> wrote in message
news:%23N8g%23O64EHA.2568@TK2MSFTNGP11.phx.gbl...
All I can find on Column Width is that the measurement I see displayed
is
how many characters of the current font will fit across the cell. Is
this
correct?!? Is there any way to get the column width in inches?

Ed