excel vba問題

IMG-20160504-WA0003.jpg
2016-5-4 21:34


我想做到圖中效果,成句vba應點寫

Col A 本身已經排序?

大概是這樣:(ps.我無真係 Check 過)
  1. dim myRow as integer
  2. myRow=3
  3. do
  4.   if cells(myRow,1)=cells(myRow-1,1) then cells(myRow,2)=cells(myRow-1,2)
  5.   myRow=myRow+1
  6. loop until(cells(myRow,1)="")
複製代碼

TOP