Thread: Copy Problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sharpie23 sharpie23 is offline
external usenet poster
 
Posts: 6
Default Copy Problem

I am having a problem with a copy function


here is the code

Dim Dest As Range


Set Dest = Worksheets("Entries by school").Range("B3")

With Worksheets("100m")
..Range("B4:I15").Copy Destination:=Dest

End With
----------------------------
The Problem is that every thing copies correctly except for cell b4 of
"100m". So basically everything is where it should be but cell b3 of
"Entries by school is blank?

Any ideas as to why?


-Ryan