Results 1 to 5 of 5

Code not working on windows97

Threaded View

Dave69rock Code not working on windows97 11-14-2008, 02:25 AM
mrice The line is failing because... 11-14-2008, 03:14 AM
Dave69rock Hi Martin I didn't write... 11-14-2008, 03:32 AM
Dave69rock Hi Martin My original post... 11-14-2008, 07:27 AM
Dave69rock Can Anyone Help Dave 11-15-2008, 01:39 AM
  1. #1
    Forum Contributor
    Join Date
    08-22-2008
    Location
    S-o-t
    MS-Off Ver
    Office 2000 & 2010
    Posts
    166

    Code not working on windows97

    Hi

    I got this code off here and it works really well on my home pc which is using widows 2000 however i need it for work and they are using windows 97.

    I get an error with the code in red
    I have attached the sheets this refers to, and when i run the code it deletes the dates it matches up with in the master rota sheet which it shouldn't

    Sub ExportIt()
      Workbooks.Open (ThisWorkbook.Path & "\master rota.xls")
      Set outsh = Sheets(ThisWorkbook.Sheets("rota").Range("B4").Value)
      
      ThisWorkbook.Activate
      For Each ce In Range("G6:G50")
        If Not IsEmpty(ce) Then
          Set findit = outsh.Range("G:G").Find(what:=ce.Value)
          For j = 8 To Cells(2, Columns.Count).End(xlToLeft).Column
            outcol = Evaluate("=SUMPRODUCT(('[Master Rota.xls]" & outsh.Name & "'!$2:$2=" & Cells(2, j).Address & ")*('[Master Rota.xls]" & outsh.Name & "'!$3:$3=" & Cells(3, j).Address & ")*COLUMN('[Master Rota.xls]" & outsh.Name & "'!$2:$2))")
            outsh.Cells(findit.Row, outcol).Value = Cells(ce.Row, j).Value
          Next j
        End If
      Next ce
      
    End Sub
    Hope someone can help

    Dave
    Attached Files Attached Files
    Last edited by Dave69rock; 11-21-2008 at 06:47 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