Results 1 to 10 of 10

Looping Code

Threaded View

  1. #1
    Registered User
    Join Date
    04-05-2007
    Location
    Sydney Australia
    Posts
    48

    Looping Code

    Hi All

    I am using the following code in a project and would like some help to loop it until either TRUE or #N/A is found in the active cell.

     Sheets("Sheet1").Select
    Range("a65536").End(xlUp).Offset(0, 17).Select
     If ActiveCell.Value = False Then
     Range("a33", Range("a33").End(xlToRight)).Select
     Selection.Copy
     Range("a65536").End(xlUp).Offset(1, 0).Select
     ActiveSheet.Paste
     Application.CutCopyMode = False
     Range("a65536").End(xlUp).Offset(0, 17).Select

    Thanks for any assistance

    Jeff
    Last edited by VBA Noob; 04-28-2007 at 02:42 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1