Thread: Greater than
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Oldjay Oldjay is offline
external usenet poster
 
Posts: 337
Default Greater than

Thanks so much

"oldjay" wrote:

Whats wrong with this?
Windows("TempData.XLS").Activate 'Recalls scrap rates
If D21 0 Then
Range("D21:D23").Select
Selection.Copy
Windows(MasterSheet).Activate
Range("AD21").Select
Selection.PasteSpecial Paste:=xlFormulas
End If