View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike[_2_] Mike[_2_] is offline
external usenet poster
 
Posts: 9
Default calculate now for user defined functions?

Hi, if I manually or programmatically paste data into 2+ cells with user
defined functions only the first cell's function is executed. Is there some
sort of equivalent to Calculate or some other way to force this? I have
found that if I manually cut the formula from the cell and paste it back
into the same cell, it executes, but that seems hacky and burdensome.

Thanks,
Mike