Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I have been able to get everything to do what I need it to do, but when I
added the Do...Until Loop it gets hung up. Here is what I have so far: # Dim aRange As Range # Set aRange = ActiveCell # # # 'Do Until ActiveCell.Value = "" # ActiveCell.Select # Selection.Cut # aRange.Offset([3], [-1]).Select 'When I add the Do Loop it gets stuck here! # ActiveSheet.Paste # ActiveCell.Copy # # aRange.Offset([0], [1]).Select # Selection.End(xlDown).Offset([0], [-1]).Select # ActiveSheet.Paste # Application.CutCopyMode = False # ActiveCell.Select # Range(Selection, Selection.End(xlUp)).Select # Selection.FillUp # ActiveCell.Select # Selection.End(xlDown).Select # ActiveCell.Select # Selection.Offset([4], [1]).Select # 'Loop # # End Sub Any suggestions??? Also, if any of this code can be cleaned up feel free to offer ideas! Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel vs. Spreadsheet in MS Works 8.0 | Excel Discussion (Misc queries) | |||
works document trying to read in excel | New Users to Excel | |||
Please help - formula works in some cells but evaluates to #value in others | Excel Worksheet Functions | |||
Works 4.0(wks) needs to be converted to Excel 2003 | Excel Discussion (Misc queries) | |||
How do I convert works file to excel without works software? | Excel Discussion (Misc queries) |