ExcelBanter - macro copy problem

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - macro copy problem (https://www.excelbanter.com/excel-discussion-misc-queries/71215-re-macro-copy-problem.html)

flummi

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

JaimeTimbrell

macro copy problem

Thanks very much for your help. I will also try this approach and see which
is the best - thanks again.

"flummi" wrote:

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

All times are GMT +1. The time now is 07:17 PM.