LiAD;470320 Wrote:
Hi,
Please could some-one give me the If structure to use for VB.
Something
very trivial such as
if cell 0<ag4<=25 do a4*3
else if ag425 do a4*10
else do nothing
end
I would like to get the structure then I can try and build the rest of
code.
Thanks
LiAD
or:Sub blah()
Select Case Range("AG4")
Case Is 25
x = Range("A4") * 10
Case Is 0
x = Range("A4") * 3
End Select
End Sub
--
p45cal
*p45cal*
------------------------------------------------------------------------
p45cal's Profile:
http://www.thecodecage.com/forumz/member.php?userid=558
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=129979