• 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. G

    vba code for SUM without using worksheetfunction

    Hi All, Should be a simple one: Is there a way of summing a range in VBA without using worksheetfunction? Unfortunately google isn't a lot of use for this kind of thing, as searching for "without" doesn't really work. Cheers, George
  2. G

    Macro to reference workbook based on activesheet

    Hi all, I'm at a fairly basic understanding of macros, but I figured this would be a good little project to start getting my head around it. Basically, what I'm looking to do is the following: 1) Extract the name of the active worksheet; 2) Open a workbook with the same name as this...
  3. G

    VBA help - index and named ranges (also colours)

    Hi all, I'm still learning a lot about VBA, so I'm sure this first one is a relatively simple question: I'm after a function that does exactly the same thing as INDEX when used in a spreadsheet, specifically when working with a named range. The second question I think is a little more...
  4. G

    for each cell in range - work by row or by column

    Hi all, in VBA, the statement For Each Cell In Range is used quite a bit. My question is, does this function cycle through by row or by column, i.e. for the range A1:B3 would it work through in the order a1, a2, a3, b1, b2, b3 or a1, b1, a2, b2, a3, b3 I'm sure this is something that...
  5. G

    Volatile or non Volatile, that is the question

    Hi All, Not a specific question really, but I've been using OFFSET for my lookups for a while, and I'm aware that for resource efficiency I should be using INDEX. My issue with INDEX is that it requires me to know exactly how large my data set is (unless I'm not understanding it properly -...
  6. G

    Sampling excel 2003

    Hi all, Odd question here (I've already tried the search to no avail) - I need to take a sample from a large data set (~600 entries) so I can make a graph that's a bit more readable. The data is year-on-year turnover (2011 vs 2012). I'd like to take either a random sample or systematic...
  7. G

    Charting - hide an axis with a checkbox

    Is it possible to hide/show an x or y axis with a checkbox? Basically I've got a chart with two y axes, one showing value, one showing volume. I'm controlling if value or volume or both are plotted with two checkboxes, is there a way to say "If (linked cell) is true, show (y1 or y2)"? I'm...
  8. G

    Conditional formatting with 255 colours

    Hi All, I recently came to the conclusion that my spreadsheets just aren't colourful enough. To that end, I decided to bodge out some VBA code to give me a full range of cell shading from RGB(1,255,1) to RGB(255,1,1) - increasing red by one each iteration and decreasing green by one. Perhaps...
Back
Top