+ Reply to Thread
Results 1 to 3 of 3

Error 2029 - Trying to run an 07' file on 03'

Hybrid View

  1. #1
    Forum Contributor PY_'s Avatar
    Join Date
    09-23-2008
    Location
    Houston
    MS-Off Ver
    Office 2016
    Posts
    289

    Error 2029 - Trying to run an 07' file on 03'

    I have a file i made in 2007 that runs fine but when i try to run it in 2003 i get an error 2029 on the code below. It runs fine until the "Lock Partition Walls Cells" section. If i comment out those lines, it will error on the "Lock Framed Opening Cells"


    Am i hitting a limit in my code somewhere that 2003 can not get past?



    ' Lock Open Walls Cells - Partition Walls - Framed Openings
    
    Private Sub lockCells_OpenWalls()
    Dim i As Long
    Dim e As Long
    Dim f As Long
    Dim g As Long
    Dim j As Long
    
    
    
    Sheets("Gen_3").Activate
    For i = 243 To 306
       If Range("H" & i).Value = "" Then
           Range("O" & i & ":V" & i).Cells.Locked = True
           Range("X" & i & ":AF" & i).Cells.Locked = True
       End If
    Next i
    
    For e = 243 To 306
       If Range("H" & e).Value = "None Requested" Then
           Range("X" & e & ":AF" & e).Cells.Locked = True
       End If
    Next e
    
    For f = 243 To 306
       If Range("C" & f).Value = "Front Sidewall:" Or Range("C" & f).Value = "Back Sidewall:" Then
           Range("X" & f & ":AF" & f).Cells.Locked = True
       End If
    Next f
    
    ' Lock Partition Walls Cells
    
    For g = 111 To 238
       If Range("W" & g).Value <> "Sheeted one side w/:" Then
           Range("AB" & g & ":AH" & g).Cells.Locked = True
       End If
    Next g
    
    
    ' Lock Framed Opening Cells
    
    For j = 459 To 562
       If Range("H" & j).Value = "" Then
           Range("N" & j & ":R" & j).Cells.Locked = True
           Range("T" & j & ":X" & j).Cells.Locked = True
       End If
    Next j
    
    
    
    
    End Sub
    Last edited by PY_; 12-20-2010 at 11:26 AM.

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,342

    Re: Error 2029 - Trying to run an 07' file on 03'

    Hi PY_
    error 2029 is cell name error
    try..
     Range("a" & j & ":R" & j).Locked = true
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Forum Contributor PY_'s Avatar
    Join Date
    09-23-2008
    Location
    Houston
    MS-Off Ver
    Office 2016
    Posts
    289

    Re: Error 2029 - Trying to run an 07' file on 03'

    Easy fix! Thank you pike.

+ 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