View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ralf Ralf is offline
external usenet poster
 
Posts: 4
Default setting excel formula from code

On Jul 14, 8:25*am, Ralf wrote:
Here is the code I am using to set the formula. *It shows as text, not
as the sum of the 2 cells as I am wanting.

dw_6.SetItem(2, 1, " =SUM(D5:D6)")


Sorry, bad info. The SetItem is used to set the values in a data
window.
I am not sure just yet how the data window is used to post the values
to excel.
I will post that info when found