在sheet1中有红蓝绿(3、4、5)三种颜色的行,如何编写vba使这些有颜色的行挑出来保存到sheet2中。
或者,将没有颜色的单元格删掉或隐藏……谢啦
ç¨ä¸é¢ç代ç ï¼å¯ä»¥ææ¯ä¸è¡Aåçå¡«å é¢è²åå ¥Fåä¸ï¼å¦æFåå·²ç»ä½¿ç¨å¯ä»¥æ¹ä¸ºå ¶å®åï¼ï¼
Option ExplicitSub ygb()
Dim i As Long
For i = 1 To Sheet1.UsedRange.Rows.Count
Sheet1.Cells(i, "F") = Sheet1.Cells(i, "A").Interior.ColorIndex
Next i
End Sub
Option Explicit
Sub ygb()
Dim i As Long
For i = 1 To Sheet1.UsedRange.Rows.Count
Sheet1.Cells(i, "F") = Sheet1.Cells(i, "A").Interior.ColorIndex
Next i
End Sub
温馨提示:答案为网友推荐,仅供参考