¥i¥H±NÀx¦s®æªº¤º®eÅܦ¨VBAªºµ{¦¡½X¶Ü?

woteil

Sub Test()
        IF CELLS(X,Y)>CELLS(I,J) THEN  ......'do something
End Sub

A1=CELLS(X,Y)>CELLS(I,J)

´N¬O¦bSub Test¤¤¬õ¦âªº±ø¥ó,¥i¥H±qA1Àx¦s¤¤°ÊºA§ì¨ú¶Ü?

Sub Test()
        IF CELLS(X,Y)>30 THEN  ......'do something
End Sub

A1=CELLS(X,Y)>30

loquat

¦^´_ 1# woteil
±z应该¬O这个·N«ä§a
A1¤¤¥i¥H写¥ô·N逻辑ªí达¦¡

1. Sub Test()
   
2.    If [A1] Then
   
3.       'Do Sth. here
   
4.    End If
   
5. End Sub

½Æ»s¥N½X

Joforn

¨Ï¥ÎScriptControl¥i¥H¹ê²{¨ú­È¡C

e-bbm

cells(x,y) = "=¤½¦¡"& c
c ¬OÅܼÆ