ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¦p¦ó¼g¥¨¶°²M°£¦³ÃC¦âÀx¦s®æªº¤º®e

¦p¦ó¼g¥¨¶°²M°£¦³ÃC¦âÀx¦s®æªº¤º®e

½Ð±Ð¤j¤j¡A¦p¦ó¼g¥¨¶°²M°£¦³ÃC¦âÀx¦s®æªº¤º®e
ÁÂÁÂ!

¹Ï¤ù.png
2016-5-20 09:30


²M°£¦³ÃC¦âÀx¦s®æ¤º®e.zip (15.51 KB)

½Ð¨Ï¥Î©³¤U¥N½X
Cells.Interior.Color = xlNone
¸Õ¸Õ¬Ý~

TOP

Sub TEST_A()

For A = 1 To Cells(Rows.Count, "A").End(3).Row

If Cells(A, 1).Interior.ColorIndex <> xlNone Then

Cells(A, 1).Value = ""

End If

Next

End Sub
cjw

TOP

¥»©«³Ì«á¥Ñ kim223824 ©ó 2017-7-29 09:46 ½s¿è

Sub TEST_B()
         Cells.ClearContents
End Sub

TOP

        ÀR«ä¦Û¦b : §Ú­Ì³Ì¤jªº¼Ä¤H¤£¬O§O¤H¡D¥i¯à¬O¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD