View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Pierce John Pierce is offline
external usenet poster
 
Posts: 93
Default Data Field in Pivot Table

Thanks Tom, Thanks Dave, for the explanation and code.
I tried .Offset(0, 3).Value = "'" & Format(StartDate, "mm/yy")
and it works perfectly for me. Thanks again.