Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Browse Site by Tags

Showing related tags and posts accross the entire site.
  • Using a Class Property to do more than just Assign or Query a Value

    The purpose of this article is to introduce various capabilities of a class property. It is not meant to serve as an introduction to classes and objects. See the references section for introductory pages. The typical use of a Class Property is to assign a value or to query its value as in the [......
    Posted to Daily Dose of Excel (Weblog) by Anonymous on Fri, May 9 2008
  • Testing Strings Using Left

    The "wrong" way: Sub FindTotals()         Dim rCell As Range         For Each rCell In Sheet1.Columns(1).Cells         If Left$(rCell, 5) = "Total" Then             'Do...
    Posted to Daily Dose of Excel (Weblog) by Anonymous on Mon, Apr 28 2008
  • Random Sorts

    Red wants to have a kind-of lottery for his students. He will award them prizes based on a random drawing, but wants to weight each student based on the number of assignments turned in. Normally, I would accomplish this by typing the name of each student in column A one time for every [...]
    Posted to Daily Dose of Excel (Weblog) by Anonymous on Sun, Mar 23 2008
Page 1 of 1 (3 items)
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.