L欄全欄搜尋chr(10) 改為換行符號. For i = 1 To Sheet1.UsedRange.Rows.Count; Range("L" & i) = VBA.Replace(Range("L" & i), "chr(10)", Chr(10)); Next i.
確定! 回上一頁