| 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 | |
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!