Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro copy problem | Excel Discussion (Misc queries) | |||
copy from Excel to Word by macro with certain for | Excel Discussion (Misc queries) | |||
macro problem | Excel Worksheet Functions | |||
copy text between 2 open workbooks via macro | Excel Worksheet Functions | |||
Macro problem | New Users to Excel |