Results 1 to 9 of 9

While Loop Object Error

Threaded View

Ascension While Loop Object Error 10-04-2010, 01:10 PM
Ascension Re: While Loop Object Error 10-04-2010, 01:36 PM
Andrew-R Re: While Loop Object Error 10-04-2010, 01:47 PM
Ascension Re: While Loop Object Error 10-04-2010, 02:03 PM
Ascension Re: While Loop Object Error 10-04-2010, 02:07 PM
Ascension Re: While Loop Object Error 10-04-2010, 02:32 PM
Andrew-R Re: While Loop Object Error 10-04-2010, 02:43 PM
Ascension Re: While Loop Object Error 10-04-2010, 03:00 PM
Andrew-R Re: While Loop Object Error 10-04-2010, 03:04 PM
  1. #1
    Registered User
    Join Date
    09-28-2010
    Location
    Boston, MA
    MS-Off Ver
    Excel 2007
    Posts
    31

    While Loop Object Error

    I am attempting to point excel at a named cell, fill that cell with a number, and then select the cell to the right of the active cell in the same row, and fill that cell with number + 1, until the loop is closed. When my Macro runs, I receive the "Object Required" error message.

    
    Sub Populate()
        Dim Counter As Integer
        Counter = 1
        While Counter < EndingMonth.Value
            If Counter = 1 Then ActiveCell.Range(FirstMonthHeading).Select Else _ ActiveCell.Select
            ActiveCell.FormulaR1C1 = Counter
            ActiveCell.Offset(0, 1).Range(FirstMonthHeading).Select
            Counter = Counter + 1
        Wend
        
            
        
    End Sub
    Greatly appreciate any help.
    Last edited by Ascension; 10-04-2010 at 03:00 PM.

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