第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.给奴才做奴才的奴才
12/01/2019
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
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:
- Open Excel
- Alt + F11 to open developer mode
- 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
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
Subscribe to:
Posts (Atom)
Tennis Court in Queenstown area
Some courts are not open to public Quail Rise -45.002353534957564, 168.75157230875968 Arrowtown -44.94668233699295, 168.82240587902302 lowe...
-
《15首苏联手风琴》歌曲MP3格式打包免费下载108MB http://mydbfx.com/?p=23319 https://url02.ctfile.com/f/133802-512199102-e1f874 223首《往日时光里旧歌杂选》WAV格式音乐打包免费下载9.12...
-
Mywife 套图扫盲贴: http://rockymay.blogspot.com/2011/06/blog-post_7416.html MyWife 8050 平岡 歩 Ayumi Hiraoka MyWife 8049 井上 真弓 Mayumi Inoue ...
-
悠久百优资料库 推荐美女: 刘诗诗 景甜 AngelaBaby 24小时点击榜 [雷人雷事]昨晚和一个普通男性朋友睡在一起,发现男生的 [自然之谜]超级男女自然展[趣图]应该不违规吧?都不是 [自然之谜]性感的美臀(生活类) [两性私语]男与女的不同 丈夫...