Thread: Copying with .Value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Simon[_2_] Simon[_2_] is offline
external usenet poster
  
Posts: 89
Default Copying with .Value
Cells.Find("latest").Select
Selection.Copy Destination:=ActiveCell.Offset(0, 1)

I wish to use only the value of the cell.

What is wrong with

Cells.Find("latest").Select
Selection.Copy Destination:=ActiveCell.Offset(0, 1)

Thanks
Reply With QuoteReply With Quote