EXCELVBA(去除空格向上移ForEach) - 工作
By Iris
at 2012-11-11T00:00
at 2012-11-11T00:00
Table of Contents
各位大大好!1.Andy想從簡單的程式碼學習ForEachNext的程式設計方式1.1.http://tw.knowledge.yahoo.com/question/question?qi...冰淇淋大大指導的程式碼,Andy程度不夠,雖然已經套用到工作上,但還不了解2.Andy用ForNext試寫了程式碼如下,請大大指導如何改用ForEachNext的方式設計程式碼Sub去除空格向上移()Sheets("Sheet1").Columns("A:G").CopyColumns("O:T")Fori=[A65536].End(xlUp).RowTo4Step-1Forj=15To19Step1IfCells(i,j)=""ThenCells(i,j).DeleteShift:=xlUpNextjNextiEndSub<範例檔>http://www.funp.net
Tags:
工作
All Comments
By Rachel
at 2012-11-12T01:06
at 2012-11-12T01:06
By Hardy
at 2012-11-15T13:12
at 2012-11-15T13:12
By Madame
at 2012-11-14T15:13
at 2012-11-14T15:13
By David
at 2012-11-11T23:48
at 2012-11-11T23:48
Related Posts
【20點】關於家庭狀況
By Megan
at 2012-11-11T00:00
at 2012-11-11T00:00
星巴克認證的問題
By Connor
at 2012-11-11T00:00
at 2012-11-11T00:00
符合低收入戶的條件嗎
By Hazel
at 2012-11-10T00:00
at 2012-11-10T00:00
我該放手追他嗎?
By Tristan Cohan
at 2012-11-10T00:00
at 2012-11-10T00:00
楓之谷洗血
By Hamiltion
at 2012-11-10T00:00
at 2012-11-10T00:00