修改巨集,複製換行 - 工作
By Ina
at 2012-12-25T00:00
at 2012-12-25T00:00
Table of Contents
大師好:excel2010最大欄位為1048576,以下巨集會超過,小弟想修改能夠自動換行,原始位置在A1希望能夠往右移50,第1次從AY1開始,第2次從CW1開始,以此類推原始巨集如下:Sub複製到結果()Fori=1To40Sheets("複製").SelectActiveCell.Range("A1:T53504").SelectSelection.CopySheets("結果").SelectSelection.PasteSpecialPaste:=xlPasteValues,Operation:=xlNone,SkipBlanks_:=False,Transpose:=FalseActiveCell.Offset(53504,0).Range("A1").SelectSheets("DATA1").SelectActiveCell.Rows("1:1").EntireRow.SelectApplication.Cu
Tags:
工作
All Comments
By Edith
at 2012-12-25T22:28
at 2012-12-25T22:28
By Una
at 2012-12-26T11:44
at 2012-12-26T11:44
By Skylar DavisLinda
at 2012-12-26T14:00
at 2012-12-26T14:00
By Edward Lewis
at 2012-12-26T07:35
at 2012-12-26T07:35
Related Posts
低利率貸款
By James
at 2012-12-24T00:00
at 2012-12-24T00:00
兒少生活津貼如何申請~
By Daph Bay
at 2012-12-24T00:00
at 2012-12-24T00:00
是壓力太大嗎??
By Frederic
at 2012-12-24T00:00
at 2012-12-24T00:00
請問低收入戶的計算方式,謝謝
By Dinah
at 2012-12-24T00:00
at 2012-12-24T00:00
想申請102年度的低收入戶?
By Adele
at 2012-12-24T00:00
at 2012-12-24T00:00