例如選擇D3後凍結窗格 , 如何用VBA得到D3這個地址？

如果沒有隱藏 (A, B, C column),  可用

ActiveWindow.SplitRow + 1

ActiveWindow.SplitColumn  + 1

(閱讀全文)

Sub DelInImmedate()
    Debug.Print Now
    Application.SendKeys "^g ^a {DEL}"
End Sub

API Method: http://www.dailydoseofexcel.com/archives/2004/06/09/clear-the-immediate-window/

如果要判斷剪貼簿是否有資料可以使用 CountClipboardFormats API 函數
 

Declare Function CountClipboardFormats Lib "user32" () As Long

Function IsClipboardEmpty() As Boolean
If CountClipboardFormats = 0 Then
  IsClipboardEmpty = True
Else
  IsClipboardEmpty = False
End If
End Function

(閱讀全文)

http://www.google.com.hk/search?complete=1&hl=zh-TW&q=ExtractFlash&btnG=%E6%90%9C%E5%B0%8B&meta=lr%3Dlang_zh-CN%7Clang_zh-TW&aq=f&oq=

 這 ExcelHome 文章完全沒有提過 !!!!

http://club.excelhome.net/thread-237225-1-1.html

(閱讀全文)

A VBA topic on Filtering by the Active Cell's Value, Font Color or Fill Color in Excel 2007 by Ron de Bruin.

Details: http://www.rondebruin.nl/colorfilter2007.htm

The above link also lead you to download an Add-in  (CommandBar Tools) to find ID numbers.

(閱讀全文)

Chijanzen 的個人網站停了頗長的時間，偶然遇上，舊雨新知請訪問一下

停了2年，從新出發的網站

本人因為工作停了2年的網誌，終於偷偷的複站了
選上了 Wordpress 重新出發，喜歡我的網誌的請加連結
路過的也感謝你參觀

http://chijanzen.net/wp/

2003運行完全沒問題的 , 但2007就運行不能了

Question

(閱讀全文)

 Information

If you run the code in Excel 2007 it will look at the FileFormat of the parent workbook and save the new file in that format.
Only if the parent workbook is an xlsm file and if there is no code in the new workbook it will save the new file as xlsx,
If the parent workbook is not an xlsx, xlsm, or xls then it will be saved as xlsb.

This are the main formats in Excel 2007 :

51 = xlOpenXMLWorkbook (without macro's in 2007, xlsx)
52 = xlOpenXMLWorkbookMacroEnabled (with or without macro's in 2007, xlsm)
50 = xlExcel12 (Excel Binary Workbook in 2007 with or without macro’s, xlsb)
56 = xlExcel8 (97-2003 format in Excel 2007, xls)

More details and examples: http://www.rondebruin.nl/saveas.htm

(閱讀全文)

Please read this post:

http://www.ozgrid.com/forum/showthread.php?t=71409

wangminbai 一位令我對 Excel 再產生興趣的小伙子

A remarkable topic to clear Office Clipboard written in Chinese Simplified.  

(閱讀全文)

 Thanks

(閱讀全文)