+ Reply to Thread
Results 1 to 3 of 3

"Do...Until" problem (Error 1004)

  1. #1
    Registered User
    Join Date
    12-11-2008
    Location
    perth
    Posts
    4

    "Do...Until" problem (Error 1004)

    Hi.

    I'm trying to find the Cell that contains the string "Grand Total" along row 5.
    The following code is giving me Error 1004

    Dim column As Long
    column = 1
    Do Until ActiveWorkbook.ActiveSheet.Cells(5, column) = "Grand Total"
    column = column + 1
    Loop

    The "Do Until ActiveWorkbook.Activ...." line is highlighted in Debugger as the problem line.

    Any ideas?
    Last edited by rylo; 12-15-2008 at 07:35 PM.

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591
    Hi

    Probably doesn't contain the required string....

    Does it actually exist on that row?


    rylo

  3. #3
    Registered User
    Join Date
    12-11-2008
    Location
    perth
    Posts
    4
    wow, im an idiot. row 4 >.<

+ Reply to Thread

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