12/01/2019

《李敖有话说》全集目录

第001集 2004.03.08.我终于有一个机会在这里抛头露面
第002集 2004.03.09.台湾人说想独立全国人民都笑了
第003集 2004.03.10.沐猴而冠和Democrazy
第004集 2004.03.11.膀胱容尿有力立院审案好处多
第005集 2004.03.12.民主政治的不当之处
第006集 2004.03.15.泄露天机 看看李登辉的嘴脸
第007集 2004.03.16.李登辉是个认贼作祖的小人
第008集 2004.03.17.“公投”丐词魔术骗你不商量
第009集 2004.03.18.没有台湾问题,根本是中美的问题
第010集 2004.03.19.给奴才做奴才的奴才

5/12/2019

How to Close Excel without Prompting Dialogue

ALT + F11, insert a new module.



VBA: Close without Saving


Sub Auto_Close()

    ThisWorkbook.Saved = True

End Sub

VBA: Close with saving.


Sub Auto_Close()
    If ThisWorkbook.Saved = False Then
        ThisWorkbook.Save
    End If
End Sub

5/10/2019

Force Excel Column to Proper/Lower Case

It need to be VBA function to force it happen:


  1. Open Excel
  2. Alt + F11 to open developer mode
  3. Add following code 



VBA code: Force text string to Lowercase
1
2
3
4
Private Sub Worksheet_Change(ByVal Target As Range)
'Update 20140603
Target.Value = VBA.LCase(Target.Value)
End Sub
VBA code: Force text string to proper case
1
2
3
4
Private Sub Worksheet_Change(ByVal Target As Range)
'Update 20140603
Target.Value = Application.WorksheetFunction.Proper(Target.Value)
End Sub

4/01/2019

How to Avoid Disk 100% for Utorrent

Follow these steps:

1. Make sure you are using uTorrent 2.2.1, because that's the most stable and most allowed torrent client on every torrent site. You can download it from http://utorrent.hu/download/utorrent-2-2-1-2/
2. Open the uTorrent settings (CTRL+P)
3. Tick the preallocate files button and untick all the updating and data sending related things
4. Go to advanced settings
5. Set bt.prio_first_last_piece to true
6. Set diskio.coalesce_write_size to 8388608
7. Set diskio.flush_files to false
8. Set diskio.sparse_files to true
9. Go to cache settings
10. Tick the override default cache, and set the cache size to 368MB
11. Apply and save the settings
12. After restarting uTorrent you will see way less or maybe absolutely no disk overload issues anymore