View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Frankey Frankey is offline
external usenet poster
 
Posts: 1
Default Formula Not Working-Help Please!!!


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