Book Home Page Bloglines 1906 CelebrateStadium 2006 OfficeZealot Scobleizer TechRepublic AskWoody SpyJournal Computers Software Microsoft Windows Excel FrontPage PowerPoint Outlook Word Host your Web site with PureHost! 
Saturday, February 20, 2010 – Permalink – Selection AddressWhat's the count". . . know what range is selected at any given time. You can look at the Name Box, but that only show the active cell." Display number of Rows and Columns See all Topics excel Labels: Customize, Formulas, Macros, Reference, Shortcuts, Tips, VBA <Doug Klippert@ 3:59 AM
Comments:
Post a Comment
Wednesday, January 20, 2010 – Permalink – Help ID'sVBA codeWhen you build a macro, you can call up information from the Excel Help file.Ron DeBruin has the information needed through 2007. Right clicking the Helpfile and choosing Properties will show the HP####### number in 2010. Help Context IDs for Excel See all Topics excel <Doug Klippert@ 3:00 AM
Comments:
Post a Comment
Thursday, October 29, 2009 – Permalink – Hep MeHelp topic locationsThis from Ron de Bruin:
Help Context IDs for Excel See all Topics excel <Doug Klippert@ 3:09 AM
Comments:
Post a Comment
Wednesday, September 30, 2009 – Permalink – When 28 is 30How long is a month?When you use the banker's DAYS360 function to calculate the number of days between two dates, you can get an odd answer. If you use the DAYS360 function with a start date of February 28 and with an end date of March 28, a value of 28 days is returned. You expect a value of 30 days to be returned for every full month. (12*30=360) This behavior may occur if you use the U.S. method, also known as the NASD method, with the DAYS360 function. To work around this behavior, use the European method with the DAYS360 function. With the European method starting dates and ending dates that occur on the 31st of a month become equal to the 30th of the same month. To use the European method with the DAYS360 function, use the following syntax: =DAYS360(cell number of start date,cell number of end date,TRUE) Using FALSE or omitting the third parameter uses the U.S. method Support.microsoft.com An unexpected value with the DAYS360 function See all Topics excel Labels: Functions, Reference, Troubleshooting <Doug Klippert@ 3:19 AM
Comments:
Post a Comment
Wednesday, July 08, 2009 – Permalink – Polyglot PolynomialsToolPak TranslatorI was disappointed recently when I tried to look up Eric Desart's ToolPak translator. I found his site "niet beschikbaar." I won't use the boy and wet thumb story, but Ron de Bruin did spring up to save the day and make the download available. "Ever wanted an oversight of the AnalysisToolPak AddIn functions, their descriptions, their arguments, their VBA and Procedure names, and all of this in your LOCAL language including translations versus the corresponding English names? Analysis ToolPak Translator See all Topics excel <Doug Klippert@ 3:03 AM
Comments:
Post a Comment
Sunday, June 14, 2009 – Permalink – Julian DatesGregorian to/from JulianJulian dates refer to the number of days from the first of the year and the number of days until the end of the year. The year 45 has been called the "year of confusion," because in that year Julius Caesar inserted 90 days to bring the months of the Roman calendar back to their traditional place with respect to the seasons. This was Caesar's first step in replacing a calendar that had gone badly awry. Caesar created a solar calendar with twelve months of fixed lengths and a provision for an intercalary day to be added every fourth year. As a result, the average length of the Julian calendar year was 365.25 days. Calendars by L. E. Doggett From Chip Pearson's site CPearson.com: "Many applications (especially mainframe systems) store dates in the Julian format, which is a 5digit number, consisting of a 2digit year and a 3digit dayofyear number. For example, 24August1999 is stored as 99236, since 24August is the 236th day of the year. Excel does not support Julian dates directly, but you can use them with only a few fairly simple formulas. US Naval Observatory has this definition (and a calculator): Julian dates (abbreviated JD) are simply a continuous count of days and fractions since noon Universal Time on January 1, 4713 BCE (on the Julian calendar). Almost 2.5 million days have transpired since this date. April 29, 2004 at 6:00 AM would be 2453854.75 See all Topics excel <Doug Klippert@ 3:43 AM
Comments:
Post a Comment
Friday, May 08, 2009 – Permalink – Data from the Other SheetSometimes we must go next doorHere is a discussion about how to use data that may be on a different worksheet, or another workbook. Getting data from other sheets can be very easy: or it can be very hard, it all depends on what you need to do. This article looks at some of the ways you can get data from other sheets.Methods In Excel Also: BetterSolutions.com Cell References See all Topics excel <Doug Klippert@ 3:14 AM
Comments:
Post a Comment
