| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Aug | Nov » | |||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| 8 | 9 | 10 | 11 | 12 | 13 | 14 |
| 15 | 16 | 17 | 18 | 19 | 20 | 21 |
| 22 | 23 | 24 | 25 | 26 | 27 | 28 |
| 29 | 30 | 31 | ||||
There is nothing that can be done on Monday mornings that can’t be done on Tuesday afternoons - save breakfast - so take a peak at these. And for god sake Mike C, you’re spilling your coffee!
Possibly not work safe.
Funny name, but it gets a bit interesting at “Br#####k’s formal parent language” - where […]
The Excel Developers Kit has been out of print for almost a decade, sadly there has been no update, but you can find a e-copy here:
http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/office97/html/edkfrnt.asp
Most of the stuff is out of date now and much of the C++ stuff just wont work - I understand that some of it didn’t work when it was […]
You know the score, you've done a pivot table and there are a load of empty cells. You want to fill them up:
[NB: you have to copy the PT as values or the code will fail!]
I use this almost every day:
Sub fill_in()
Dim cell As Object
Application.ScreenUpdating = False
For Each cell In Selection
[...]
UPDATE - Check out the comments for a better solution! - boy I sure am glad I finished the post the way i did!
In VB.Net (well any dot net language really) you can add a “SplitContainer” control – I like to call it a splitter control. It’s good, it’s great for getting your .Net controls [...]
Simon (am I obsessed with him?) found this paper about the Excel 2007 bug. It’s not only an excellent investigation in to that bug but is generally very interesting to read, and highlights some of the complexities behind the workings of our favour Spreadsheet(thats Excel btw), well worth a read if you have a few [...]
This years Excel user conference is to be held in sunny Cambridge. New for this year is a Developer day, which looks like it could be good fun – although I’m not sure of the pricing for that day – Simon? Damon?
Simon, such that he is, is taking suggestions for topics, although what he [...]
Over at JMT there was a strange question asked. How do you get the cells that a drawn shape lies over? I'm was amazed to see that there were methods in the OM to get this, heres some example code
Sub MShapesLocation()
''Code by Ross McLean - Methods In Excel
''Tells you the top left and bottom right [...]