LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default Everything works...but can't get it to Loop

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel vs. Spreadsheet in MS Works 8.0 helen Excel Discussion (Misc queries) 5 November 24th 06 08:41 AM
works document trying to read in excel Candilinn New Users to Excel 4 July 13th 06 07:39 AM
Please help - formula works in some cells but evaluates to #value in others Ullie Excel Worksheet Functions 2 June 14th 06 08:16 PM
Works 4.0(wks) needs to be converted to Excel 2003 BJB Excel Discussion (Misc queries) 2 July 15th 05 03:49 PM
How do I convert works file to excel without works software? CatMB Excel Discussion (Misc queries) 1 June 21st 05 04:12 PM


All times are GMT +1. The time now is 09:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"