Thread: Type mismatch problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
C01d[_6_] C01d[_6_] is offline
external usenet poster
  
Posts: 1
Default Type mismatch problem

Instead of:
StartDate = Sheets("Macro Data").Cells("B1")

Try:
StartDate = Sheets("Macro Data").Cells("B1").Value


--
C01d
------------------------------------------------------------------------
C01d's Profile: http://www.excelforum.com/member.php...o&userid=34422
View this thread: http://www.excelforum.com/showthread...hreadid=546956

Reply With QuoteReply With Quote