View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
EmmieLou EmmieLou is offline
external usenet poster
 
Posts: 13
Default Paste Special, Values only

I have part of the code here, I want to include a paste special to get only
the value of cell H3, not the formula. The value comes from a lookup
function in the sheet "Summary" and I want to paste the value in to another
worksheet, "Pedigrees."

Call InsertData("Pedigrees", "N", GetData("Summary", "H3"))
Thanks!!