VBA for excel 儲存格

加框線
http://www.blueshop.com.tw/board/FUM20050110200833I8T/BRD20070604154513A8F.html
http://forum.twbts.com/thread-9862-1-1.html

With Sheet1.Range("a1:c4").Borders
    .LineStyle = xlContinuous
    .ColorIndex = xlThin
    .Weight = xlAutomatic
End With


合併儲存格
https://tw.knowledge.yahoo.com/question/question?qid=1011091300690

Sheet1.Range("a1:a4").Merge


文字置中
http://smile0103.blogspot.tw/2014/02/excel-vba_6447.html

Sheet1.Cells(1, 1).HorizontalAlignment = xlCenter


用 cell 選擇 range
http://blog.xuite.net/crdotlin/excel/9092240-%E7%94%A8Range%EF%BC%9F%E7%94%A8Cells%EF%BC%9F

Sheet1.Range(Cells(2, 2), Cells(5, 5)).Value = 5