Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Quite simple Im sure
Dim x As Integer x = 1 For x = 1 To 12 Worksheets(x).Select Range("A5:I5").Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy Worksheets("Summary").Select Range("a65536").Select Selection.End(xlUp).Select ActiveCell.Offset(1, 0).Select ActiveSheet.Paste Next x I am trying to copy the data from each sheet from a5:i5 down but it doesnt work if there is nothing in the range. How do I fix it? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
help with debug | New Users to Excel | |||
debug | Excel Programming | |||
help with debug | Excel Programming | |||
No debug box | Excel Programming | |||
debug - | Excel Programming |