Method "range of object_global _failed

[larrygreg]

I have some simple code

Range("B" & Start & ":S" & end).copy

I am getting the 1004 error. I dont understand why? If I substitute Numbers instead of the variables it work. Am I missing something.

Thanks,

Regards,

Larry

 

[RoryA]

What are the actual values of Start and end when the error occurs?

 

[larrygreg]

Start is 6 , end is 700

 

[RoryA]

Are you certain of that, or just assuming it? Can you post the full code?