| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| Jan » | ||||||
| 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 | |
I’ve seen this sort of thing in excel before, some better than others. I tested it in a live journal account i set up and it work perfectly. Not sure about pictures though!
I’m working on a big dictor app at the moment. It’s starting to crash big time! - Often after making a small change to a VBA module it will refuse to open again in excel. I have to do a “detect and repair” to get the workbook to open. I’m not sure if it’s […]
Came across the VB Split fucntion which I had never used before today, fom help: (anoted)
Description
Returns a zero-based, one-dimensional array containing a specified number of substrings.
Syntax
Split(expression[, delimiter[, limit[, compare]]])
Expression, Required. ‘’the string
Delimiter, Optional. ‘’String character used to identify substring limits. If omitted, the space character (” “) is assumed to be the […]
I’ve been using this for about 6 months and it’s a brilliant tool! Gary has also been kind enough to make the full version available for free too. Excellent!
Not only can you manage all you code snippets, but you can store example file right along side them; there’s even a version that runs right off […]
From a white paper at MSDN:
EXPORTING TO EXCEL FROM OWC
Some customers have reported difficulties in exporting data from Office PivotTable Components to Excel. Microsoft has investigated these reports and determined that:
• OWC does not pass the expand state to Excel correctly, so Excel expands everything. Because all rows are set to visible, all data must […]
Theres a lot of code out there for getting the windows colour picker dialog, but it can be hard to get a RGB code out of this. For example, if you want to set the colour of a form text box, then get it's RGB value to colour a worksheet cell. (That's what i used [...]
Following a question in JMT I wrote this UDF, it finds the first lower case letter in a cell
Public Function FindLower(cell As Object)
'''Finds the first lower case letter in a cell
If cell.Cells.Count 1 Then
FindLower = "Error - enter only one cell"
Exit Function
End If
For i = 1 To Len(cell.Text)
If Asc(Mid(cell.Text, i, 1))> 90 Then '90 = [...]
This is interesting! mostly I don’t agree with it.
Office 12 is an upgrade I wouldn't mind paying for, that is, assuming that work didn't let us get free copies. Those are big words for me, considering my "I Hate Microsoft" series of blog entries. I can imagine making documents faster with Office 12, or at [...]
This is quite cool some kind of drum machine build in excel! Although it does use a .dll, still cool all, the same!
My web site is methods in excel (www.methodsinexcel.co.uk), but i find that it's not always the best way for me to put info up, so I'm giving this a whril too. If i like it i think i'll move to a blog full time.