• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. J

    Resetting Variant type

    I'm trying to write a sub that will accept either text or a value as a parameter and have encountered some behavior I don't understand. If I take this code: Sub TestInput(strText As Variant) MsgBox VarType(strText) End Sub and call it from the immediate window TestInput(53) I get...
  2. J

    Class module usage

    Does anyone have a good breakdown of why you would use a class module? I'm good with the how, just not the why. Since the collection isn't static you have to read all the members back in each time the sheet is opened. How is this much different than reading an array into memory and using...
  3. J

    OLAP + Pivot table + SumProduct

    Having read the virtues of the SumProduct function I thought I'd put it to good use. My key data source is a Pivot Table connected to an OLAP data source. The problem arises in that the data is not repeated for all the pivot fields ie the data looks like: Region------Store...
Back
Top