Results 1 to 4 of 4

Runtime error 1004

Threaded View

  1. #1
    Registered User
    Join Date
    07-07-2010
    Location
    Las Vegas
    MS-Off Ver
    Excel 2003
    Posts
    1

    Runtime error 1004

    Whenever I run the micros, I get a runtime error 1004. And when I debug it the following shows:
    Sub datacheckingstudy()
    '
    ' datacheckingstudy Macro
    ' formatting for  data for read aloud and visual checking for scoring in SPSS
    '
    ' Keyboard Shortcut: Ctrl+k
    '
        Rows("4:5").Select
        With Selection.Interior
          .Pattern = xlNone
            .TintAndShade = 0
            .PatternTintAndShade = 0
        End With
        Columns("A:A").Select
        Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
        Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
        Selection.ColumnWidth = 14.29
        Range("A1").Select
        ActiveCell.FormulaR1C1 = "Participant ID"
        Range("B1").Select
        Columns("B:B").ColumnWidth = 9
        Range("B1").Select
        ActiveCell.FormulaR1C1 = "Part "
        Range("F2").Select
        Selection.Copy
        Range("A2").Select
        ActiveSheet.Paste
        Range("A3").Select
        ActiveSheet.Paste
        Range("A4").Select
        ActiveSheet.Paste
        Range("A5").Select
        ActiveSheet.Paste
        Range("A6").Select
        ActiveSheet.Paste
        Range("F2").Select
        Application.CutCopyMode = False
        Selection.ClearContents
        Range("B2").Select
        ActiveCell.FormulaR1C1 = "Part 1"
        Range("B3").Select
        ActiveCell.FormulaR1C1 = "Part 1"
        Range("B4").Select
        ActiveCell.FormulaR1C1 = "Part 1"
        Range("B5").Select
        With Selection.Interior
            .Pattern = xlNone
            .TintAndShade = 0
            .PatternTintAndShade = 0
        End With
        ActiveCell.FormulaR1C1 = "Part 1"
        Range("B6").Select
        With Selection.Interior
            .Pattern = xlNone
            .TintAndShade = 0
            .PatternTintAndShade = 0
        End With
        ActiveCell.FormulaR1C1 = "Part 1"
        Range("C2").Select
        Selection.ClearContents
        Range("C1:AJ4").Select
        Selection.Delete Shift:=xlUp
    End Sub
    Any help would be appreciated. Thank you.
    Last edited by Leith Ross; 07-07-2010 at 10:11 PM. Reason: Added Code Tags

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