Why does this code not work?
Workbooks("TEST").Sheets(1).Cells(10, 11).Formula ="=IF(H" & 10 & "=" &
"""XYZ""" & ";" & "G" & 10 & ";" & "0)"
thx in adv.
--
Frankey
------------------------------------------------------------------------
Frankey's Profile:
http://www.excelforum.com/member.php...o&userid=35748
View this thread:
http://www.excelforum.com/showthread...hreadid=555228