Avatar
玉文 楊
11,016 views| 2  Posts

Photos

Latest Updates

台北難得一見的飯店 - 宏都金殿飯店

Read more

almost 8 years ago 0 likes  0 comment  0 shares

EXCEL - VBA 日期不同格式轉換個人巨集活頁簿

Sub 插入欄()

ActiveCell.Offset(0, 1).Select

Selection.EntireColumn.Insert

Selection.EntireColumn.Insert

ActiveCell.Offset(0, -1).Select

End Sub

Sub 切割()

x = ActiveCell.Address

Selection.TextToColumns Destination:=Range(x), DataType:=xlDelimited, _

TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _

Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar _

:="/", FieldInfo:=Array(Array(1, 2), Array(2, 2),...Read more

almost 8 years ago 0 likes  0 comment  0 shares

About

Learn More

Location (City, Country)
Taipei, Taiwan
Gender
male
Member Since
October 8, 2008