Results 1 to 6 of 6

Run Time Error 438

Threaded View

  1. #1
    Registered User
    Join Date
    09-29-2008
    Location
    USA
    Posts
    16

    Run Time Error 438

    I have the following code in a macro and when it is run I get a Run Time Error 438 Object doesn't support this property or method. This occurs at the first occurrance of the destination/source. Any suggestions?

    Sub TestDatabase()
    '
    ' TestDatabase Macro
    ' Macro recorded 11/12/2008 by JLZ
    '
    ' Keyboard Shortcut: Ctrl+t
    ' syntax is [destination].Value = [source].Value         
        Windows("File 2.xls").Range("B3").Value = Windows("File 1.xls").Range("E2").Value
        Windows("File 2.xls").Range("C3").Value = Windows("File 1.xls").Range("E3").Value
        Windows("File 2.xls").Range("D3").Value = Windows("File 1.xls").Range("E4").Value
        Windows("File 2.xls").Range("E3").Value = Windows("File 1.xls").Range("C6").Value
        Windows("File 2.xls").Range("F3").Value = Windows("File 1.xls").Range("C7").Value
        Windows("File 2.xls").Range("G3").Value = Windows("File 1.xls").Range("C8").Value
        Windows("File 2.xls").Range("H3").Value = Windows("File 1.xls").Range("E8").Value
        Windows("File 2.xls").Range("I3").Value = Windows("File 1.xls").Range("E9").Value
        Windows("File 2.xls").Range("J3").Value = Windows("File 1.xls").Range("E28").Value
        Windows("File 2.xls").Range("K3").Value = Windows("File 1.xls").Range("E29").Value
        Windows("File 2.xls").Range("L3").Value = Windows("File 1.xls").Range("E30").Value
        Windows("File 2.xls").Range("M3").Value = Windows("File 1.xls").Range("E31").Value
        Windows("File 2.xls").Range("N3").Value = Windows("File 1.xls").Range("E33").Value
        Windows("File 2.xls").Range("O3").Value = Windows("File 1.xls").Range("B29").Value
        Windows("File 2.xls").Range("P3").Value = Windows("File 1.xls").Range("B31").Value
        Windows("File 2.xls").Range("Q3").Value = Windows("File 1.xls").Range("B33").Value
        Windows("File 2.xls").Range("R3:V3").Value = Windows("File 1.xls").Range("A12:E12").Value
        Windows("File 2.xls").Range("W3:AA3").Value = Windows("File 1.xls").Range("A13:E13").Value
        Windows("File 2.xls").Range("AB3:AF3").Value = Windows("File 1.xls").Range("A14:E14").Value
        Windows("File 2.xls").Range("AG3:AK3").Value = Windows("File 1.xls").Range("A15:E15").Value
        Windows("File 2.xls").Range("AL3:AP3").Value = Windows("File 1.xls").Range("A16:E16").Value
        Windows("File 2.xls").Range("AQ3:AU3").Value = Windows("File 1.xls").Range("A17:E17").Value
        Windows("File 2.xls").Range("AV3:AZ3").Value = Windows("File 1.xls").Range("A18:E18").Value
        Windows("File 2.xls").Range("BA3:BE3").Value = Windows("File 1.xls").Range("A19:E19").Value
        Windows("File 2.xls").Range("BF3:BJ3").Value = Windows("File 1.xls").Range("A20:E20").Value
        Windows("File 2.xls").Range("BK3:BO3").Value = Windows("File 1.xls").Range("A21:E21").Value
        Windows("File 2.xls").Range("BP3:BT3").Value = Windows("File 1.xls").Range("A22:E22").Value
        Windows("File 2.xls").Range("BU3:BY3").Value = Windows("File 1.xls").Range("A23:E23").Value
        Windows("File 2.xls").Range("BZ3:CD3").Value = Windows("File 1.xls").Range("A24:E24").Value
        Windows("File 2.xls").Range("CE3:CI3").Value = Windows("File 1.xls").Range("A25:E25").Value
        Windows("File 2.xls").Range("CJ3:CN3").Value = Windows("File 1.xls").Range("A26:E26").Value
        Windows("File 2.xls").Range("CO3:CS3").Value = Windows("File 1.xls").Range("A27:E27").Value
        Windows("File 2.xls").Range("B3").Value = Windows("File 1.xls").Range("E2").Value
    
        Windows("File 2.xls").Activate
        Rows("3:3").Select
        Application.CutCopyMode = False
        Selection.Insert Shift:=xlDown
        Windows("File 1.xls").Activate
        Range("C9").Select
    
    End Sub
    Last edited by lj123; 11-13-2008 at 01:30 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