$$Excel-Macros$$ Iterate over irregular shaped range problem

2009-02-20 Thread Mark Hanley
I have set up a number of named ranges - each of which is an irregular shape (as in not rectangular). I have found that one can iterate through all cells in a rectangular range with a loop like: ' Set all cells in named range to contain 'hello' set ws = Sheets("aWorksheet") For i = 1 To ws.Range

$$Excel-Macros$$ Venn diagram creation

2009-02-07 Thread Mark Hanley
I need to create a Venn diagram with three circles and insert names into each section based on three sets of values. I'm wondering if the drawing API in VBA would be up to the job. I need to be able to position the names with x and y coordinates so that they are in the right section (i.e. I don't