View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mastermind mastermind is offline
external usenet poster
 
Posts: 36
Default Copy/Paste Range

I have a range (E10:P95) and I would like to have excel copy it and
paste the values in a range of identical size (U10:AF95). Can someone
please tell me how to do this.

I have tried using these codes:

Range("E10:P95").Copy
Range("U10:AF95").Paste

Range("E10:P95").Select
Selection.Copy
Range("U10:AF95").Select
Selection.Paste

Neither one works for whatever reason, and cause my macro to skip
sections. Does anyone know how to solve this problem? Any help would
be appreciated. Thank you.