ªð¦^¦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 : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD