Thread: Correct Format for formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
parteegolfer parteegolfer is offline
external usenet poster
  
Posts: 1
Default Correct Format for formula

Can anyone tell me what the correct format would be for this formula. I
know I am close however I keep getting a complile error


Code:
--------------------
.Offset(1, 2).Formula = "=CountIf(C7:C" & (lngLastRow - 1) ,"X")"
--------------------


--
parteegolfer
------------------------------------------------------------------------
parteegolfer's Profile: http://www.excelforum.com/member.php...o&userid=31951
View this thread: http://www.excelforum.com/showthread...hreadid=529020

Reply With QuoteReply With Quote