View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
flummi
 
Posts: n/a
Default macro copy problem

Try t organize the T1 bit in all worksheets to be in the same cell say
A1 and try this example.

EndRow = Range("a1").Value
Range("T5:AC5").Select
Application.CutCopyMode = False
Selection.Copy
Range("T6:T" + CStr(EndRow)).Select
ActiveSheet.Paste