+ Post New Thread
Results 1 to 2 of 2
Coding Thread, Excel VBA problems in Coding and Web Development; When trying to run the following piece of code I get a runtime '1004' error, select method of range class ...
  1. #1

    Join Date
    Jul 2007
    Burnley and Barnoldswick
    Thank Post
    Thanked 0 Times in 0 Posts
    Rep Power

    Excel VBA problems

    When trying to run the following piece of code I get a runtime '1004' error, select method of range class failed.

    I am trying to copy a selection of data from one sheet to anoher sheet and then moe the row down.

    The code I have is as follows:

    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
    :=False, Transpose:=False
    Application.CutCopyMode = False
    Selection.Insert Shift:=xlDown

    It keeps falling over at the section in bold, if anyone has any answers, much appreciated thanks. Have looked fro other solutions on other websites but doesnt seem to help.

  2. #2
    penfold_99's Avatar
    Join Date
    Feb 2008
    East Sussex
    Thank Post
    Thanked 167 Times in 119 Posts
    Rep Power
    Are you trying to copy a value form one field to another?

    if so try
    Sheets("examples2").Range("B3").Select = _
    Sheets("WHAT EVER THIS CALLED").Range("C33").value

    Sheets("examples2").Range("C3").Select = _
    Sheets("WHAT EVER THIS CALLED").Range("D33").value

  3. Thanks to penfold_99 from:

    cursong (13th October 2008)

+ Post New Thread

Similar Threads

  1. Looping with range in VBA, help please
    By iuppiter in forum Coding
    Replies: 2
    Last Post: 8th September 2008, 04:47 PM
  2. Excel VBA Loop Question
    By vunsev in forum Coding
    Replies: 5
    Last Post: 11th April 2008, 09:08 AM
  3. problems opening excel document
    By PEO in forum How do you do....it?
    Replies: 6
    Last Post: 7th March 2008, 10:53 AM
  4. Excel
    By Edu-IT in forum How do you do....it?
    Replies: 13
    Last Post: 7th March 2008, 09:57 AM
  5. Macro and VBA functions
    By randle in forum Windows
    Replies: 10
    Last Post: 9th February 2007, 10:32 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts